NOW (Lakehouse v1)
Returns the current date and time.
Analyze Syntax
Section titled “Analyze Syntax”func.now()Analyze Examples
Section titled “Analyze Examples”┌─────────────────────────────────────────────────────────┐│ func.current_timestamp() │ func.now() │├────────────────────────────┼────────────────────────────┤│ 2024-01-29 04:38:12.584359 │ 2024-01-29 04:38:12.584417 │└─────────────────────────────────────────────────────────┘SQL Syntax
Section titled “SQL Syntax”NOW()Return Type
Section titled “Return Type”TIMESTAMP
Aliases
Section titled “Aliases”SQL Examples
Section titled “SQL Examples”This example returns the current date and time:
SELECT CURRENT_TIMESTAMP(), NOW();
┌─────────────────────────────────────────────────────────┐│ current_timestamp() │ now() │├────────────────────────────┼────────────────────────────┤│ 2024-01-29 04:38:12.584359 │ 2024-01-29 04:38:12.584417 │└─────────────────────────────────────────────────────────┘