Skip to main content

NOW function

Returns the current date and time as a timestamp.

Syntax

NOW()

Arguments

This function takes no arguments.

Returns

A TIMESTAMP representing the current date and time.

Examples

-- Example 1: Get current timestamp
> SELECT NOW();
2025-01-15 14:30:45.123456

Notes

  • NOW() returns a timestamp without timezone.

  • The value remains constant within a single query execution.

  • For just the date portion, use CURRENT_DATE.

See Also