UNIX_TIMESTAMP

Learn how to use the UNIX_TIMESTAMP date/time function in PlaidCloud Lakehouse. Converts a datetime to a Unix timestamp - see syntax, examples, and output.

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  │
└────────────┘