Looker Studio is now called Data Studio. Learn more about this change.

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.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2026年08月26日 UTC.