> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.