Function Name |
Description |
NOW() |
The NOW() is a function, and returns a date and time specifying the current date and time according your computer's system date and time. |
DAY() |
The DAY() is a function, and return or extract the day value portion or day of the month (a whole integer number from 1 to 31) of a given input date value. |
MONTH() |
The MONTH() is a function, and return or extract the month value (a whole integer number from 1 to 12) of a given input date value. |
YEAR() |
The YEAR() is a function, and returns or extract year portion(a four digit number) of a given input date value. |
HOUR() |
The HOUR() is a function, and return or extract the hour portion of a given input time value. |
MINUTE() |
The MINUTE() is a function, and return or extract the minute portion of a given input time value. |
SECOND() |
The SECOND() is a function, and return or extract the second portion of a given input time value. |
DAYNAME() |
The DAYNAME() is a function, and returns the name of the weekday of a given input date value. |
MONTHNAME() |
The MONTHNAME() is a function, and returns a string indicating the full name of the specified month of a given input date value. |
DAYOFYEAR() |
The DAYOFYEAR() is a function, and returns a integer indicating day of the year of a given input date value. |
DATEPART() | EXTRACT() |
The DATEPART() | EXTRACT() is a function, and returns a integer number containing the specified part of a given input date time value. |
DATEADD() |
The DATEADD() | DATE_ADD() is a function, and use to add or subtract a number of time units to a date. |
DATEDIFF() |
The DATEDIFF() is a function, and use to find the difference between two dates. |