​

Overview

The CURRENT_TIMESTAMP() returns the current timestamp value representing the date and time the query was executed.

​

Syntax

CURRENT_TIMESTAMP() // The parentheses are optional

​

Examples

The following example shows how to get the current date and time with a CURRENT_TIMESTAMP()function:

SELECT CURRENT_TIMESTAMP AS "Current Time";

The final result will display the current date and time in your timezone:

-----------------------------
 Current Time                
-----------------------------
 2022-08-31 16:56:06.464016  
-----------------------------