BigQuery + Looker: Timestamp vs Datetime

[olof]

Hello, we have Looker on top of BigQuery. Currently there is a lot of mixed usage when it comes to dates and times. We’re doing some cleaning and decided that we should all try to use the same format whenever possible, to avoid converting and extracting back and forth all the time. 

No one in our team really have a strong opinion on the matter, so I’m wondering if there are any best practice recommendations? FYI we don’t operate across different time zones.

So if you recommend that we use date format X, we will try to convert all dates to format X as early as possible in the flow, and all comparisons and joins will use format X. 

Looking forward to your recommendations and tips for further reading