UNIX_TIMESTAMP (Lakehouse v2)

Converte um datetime num timestamp Unix.

Sintaxe de Analyze

func.unix_timestamp([<datetime>])

Exemplos de Analyze

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

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

Sintaxe SQL

UNIX_TIMESTAMP([<datetime>])

Exemplos SQL

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

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