sdave
sdave

Reputation: 568

timestamp difference in bigquery with date

I have used Dataiku to transfer 40 GB of data from snowflake to big query. Somehow timestamp value changed my dates completely

Instead of 2021-06-30 00:00:00 UTC the copied timestamp value is 2021-06-29 22:00:00 UTC

I am looking for a bigquery solution to cast this into the correct timestamp as loading the data again is not possible.

Can someone help please? Thanks

Upvotes: 0

Views: 110

Answers (1)

sdave
sdave

Reputation: 568

found the solution

SELECT TIMESTAMP_ADD(Day_Sts, INTERVAL 120 MINUTE) AS Day_Sts,* except (Day_Sts)

Upvotes: 1

Related Questions