Reputation:
When i select date as sept 16,i get to see sept 16 6am and sept 17 data until 5:59 AM. It is treating 24 hours from sept 16 am to sept 17 6am. Is there any issue with date field or report filter issue?
Upvotes: 1
Views: 141
Reputation: 996
For visibility purposes I am posting my comment as an answer:
As @Pentium10 mentioned:
BigQuery's date functions work based on UTC timezone. The UI you are using probably converts them into your local timezone, and you are seeing the 6 hours difference.
According to this Data Studio uses UTC standard time, but if your data set does not use UTC you can use the TODATE function to convert the date field to UTC.
Upvotes: 0
Reputation: 208042
BigQuery's date functions work based on UTC timezone. The UI you are using probably converts them into your local timezone, and you are seeing the 6 hours difference.
Upvotes: 1