CODEWITHSUNDEEP
google-bigquerylooker-studio
user9203730
user9203730

Reputation:

today's date filter showing next day data in table chart

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

Answers (2)

Miguel
Miguel

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

Pentium10
Pentium10

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

Related Questions