Categories: Context, Date/Time

CURRENT_TIMESTAMP

Returns the current timestamp for the system.

Syntax

CURRENT_TIMESTAMP() → TIMESTAMP

Examples

SELECT CURRENT_TIMESTAMP()
-- 2021-06-24 06:11:51.567000
SELECT CURRENT_TIMESTAMP
-- 2021-06-24 06:11:51.567000

Usage Notes

This function can be called without the parentheses.

Learn more about date/time formatting.