how to get current timestamp in sql server code example

SELECT CURRENT_TIMESTAMP;