SQL Server CURRENT_TIMESTAMP function returns the current date and time.
It returns the date and time from the operating system of the computer that the instance of SQL Server is running on and the format of date is ‘yyyy-mm-dd hh:mi:ss.mmm’.
It is more similar to SQL Getdate() Function.
Syntax
CURRENT_TIMESTAMP
There are no argument for this function .
Lets look at an example of CURRENT_TIMESTAMP in SQL Server.
Following statement uses CURRENT_TIMESTAMP function and returns current date and time of system.
SELECT CURRENT_TIMESTAMP AS [CurrentDateTime]
As you can see, It returns the current date and time of system.
You can also get a day and month from CURRENT_TIMESTAMP() function.
Get a day and month from CURRENT_TIMESTAMP() function
Following statement returns a date part that is a day and month from date returned by CURRENT_TIMESTAMP() function returns current date and time of system.
SELECT CURRENT_TIMESTAMP AS [CurrentDateTime], DAY(CURRENT_TIMESTAMP ) AS [CurrentDay], MONTH(CURRENT_TIMESTAMP ) AS [CurrentMonth]
As you can see, it returns a DAY and MONTH of current date. Here we have used a DAY, and MONTH function with CURRENT_TIMESTAMP function to day and month value from date.
Also Read..
813 total views, 2 views today