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.

1 Like