how to get current timestamp in sql code example

Example: sql current timestamp

SELECT CURRENT_TIMESTAMP;