Knowledge Drop

Does Looker account for daylight savings?

  • 15 June 2021
  • 0 replies
  • 107 views

Userlevel 5

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.                

 

 


0 replies

Be the first to reply!

Reply