Date and Time functions in SQL Server
In this article I will explain you the some important Date and Time functions.
Introduction
In this article I will explain you the some important Date and Time functions. SQL Server provides some useful Date and Time function such as ADDTIME(), MONTH() and HOUR() etc. The following list represent the name and description of some useful date and time function.
Name |
Description |
CURDATE() |
Return the current date |
CURRENT DATE () |
Synonyms of CURDATE() |
CURRENT TIME() |
Synonyms of CURTIME() |
ADDDATE() |
Add dates |
ADDTIME() |
Add times |
CONVERT TZ() |
Convert from one time zone to another |
DAY() |
Synonyms for DAYOFMONTH() |
DAYNAME() |
Return the name of the weekday |
DAYOFMONTH() |
Return the day of the month(1-31) |
DAYOFWEEK() |
Return the weekday index of the a |
EXTRACT |
Extract part of a date |
HOUR() |
Extract the hour |
MINUTE() |
Return the minute from the argument |
MONTH() |
Return the month from date Passed |