Notification

This Help Center is moving to Cloud. Learn more about the migration.

UNIX_DATE

Returns the number of days since 1970-01-01.

Sample usage

UNIX_DATE(Order Date)

Syntax

UNIX_DATE(date_expression)

Parameters

  • date_expression - a Date or Date & Time field or expression.

Return data type

Number

Examples

Example formula Output

UNIX_DATE(DATE(2020,11,3))

18569

Notes

This function is not available for compatibility mode date types.

UNIX_DATE ignores the time parts of a Date & Time field or expression.

Related resources

Was this helpful?

How can we improve it?
true
What's new in Looker Studio?

Learn about new features and recent changes. Looker Studio release notes live on Google Cloud.

Search
Clear search
Close search
Google apps
Main menu
8118535414192235500
true
Search Help Center
true
true
true
true
true
102097
false
false