Home » SQL GETDATE()

SQL GETDATE()

SQL GETDATE() function returns the current date and time.





It returns the system date and time in the format ‘yyyy-mm-dd hh:mi:ss.mmm‘.

There are no parameters or arguments for the GETDATE() function.

SYNTAX

GETDATE()

Lets look at an example of GETDATE() in SQL.

SELECT GETDATE() AS CURRENTDATE

 

As you can see, It returns a current date and time of system in format ‘yyyy-mm-dd hh:mi:ss.mmm’

You can also get a date part from GETDATE() Function, like if you want to get a current day and month from GETDATE() function then you can use SQL Server DAY() and Month Function.

Lets look at an example to get a current day and month from GETDATE() function.

SELECT GETDATE() AS CURRENTDATE, DAY(GETDATE()) AS CURRENTDAY, 
MONTH(GETDATE()) AS CURRENTMONTH

 

As you can see, It returns current day and current monthn as a date part .

Remember, Here day() and month() function are SQL date function that is used to get a day and month from any date.

Recommended for you

DATEPART() Function




Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.