Does Looker account for daylight savings?

Knowledge Drop

Last tested: Dec 18, 2018
 

Yes.

The timezone rules for the specified timezone will be followed. This can sometimes introduce subtle logic bugs. For example, the timezone code `ESTEDT` follows the rules of daylight savings for the Eastern Time Zone of the United States.

The timezone code `America/New_York` is identical to `ESTEDT` for all dates after the Uniform Time Act of 1966. But prior to 1966 `ESTEDT` is EST only while `America/New_York` follows the daylight savings time rules as observed in NYC.

This content is subject to limited support.                

Version history
Last update:
‎06-14-2021 05:59 PM
Updated by: