ETL: ToUnixTime

Convert a datetime value to Unix time (seconds since epoch). Use TOUNIXTIME for timestamp conversions and epoch calculations in ETL data pipelines.

Description

Returns the Unix Time for a datetime value.

Syntax

ToUnixTime(datetime_expression)

Examples

ToUnixTime(ToDate('2014-11-01T23:30:00+02:00')) returns 1414877400

Return value datatype

Long

Impact of null value

If datetime_value is null, returns null.