how to use current time in sql timestamp code example

Example: sql current timestamp

SELECT CURRENT_TIMESTAMP;