Skip to main content

NOW

Returns the current date and time.

Syntax

NOW()

Return Type

TIMESTAMP

Aliases

Examples

This example returns the current date and time:

SELECT CURRENT_TIMESTAMP(), NOW();

┌─────────────────────────────────────────────────────────┐
current_timestamp()now()
├────────────────────────────┼────────────────────────────┤
2024-01-29 04:38:12.5843592024-01-29 04:38:12.584417
└─────────────────────────────────────────────────────────┘
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today