Example
Return the current date and time:
SELECT CURRENT_TIMESTAMP;
Definition and Usage
The CURRENT_TIMESTAMP function returns the current date and time, in a ‘YYYY-MM-DD hh:mm:ss.mmm’ format.
Tip: Also look at the GETDATE() function. Continue reading SQL CURRENT_TIMESTAMP Function