UNIX_TIMESTAMP (Lakehouse v2)

Converts a datetime to a Unix timestamp.

Analyze Syntax

func.unix_timestamp([<datetime>])

Analyze Examples

func.unix_timestamp('2024-01-01 00:00:00')

┌────────────┐
│ 1704067200  │
└────────────┘

SQL Syntax

UNIX_TIMESTAMP([<datetime>])

SQL Examples

SELECT UNIX_TIMESTAMP('2024-01-01 00:00:00');

┌────────────┐
│ 1704067200  │
└────────────┘