1 of 8

DATE FUNCTIONS

2. NOW( ) 4.DATE( ) 5. DAY( ) 6.MONTH( ) 7.YEAR( ) 8. DAYNAME( ) 9.MONTHNAME( )

Date Functions operate on values of the date data type.

​

Some commonly used Date & Time functions are :

​

2 of 8

2.NOW()

This function returns the

current date and time

3 of 8

4.DATE()

This function extracts the date part of a date or datetime expression.

4 of 8

5.DAY()

This function returns the day part of a date

5 of 8

6.MONTH()

This function returns the month from the date passed

6 of 8

7.YEAR()

This function returns the year part of a date

7 of 8

8.DAYNAME()

This function returns the name of week day

8 of 8

11.DAYOFMONTH()

This function returns the day of month