GBQ equivalent function

[Alexian]

I came across timezone_hour and interval hour functions in teradata.

However not able to find the equivalent function in GBQ. Anyone aware of the same.

[BartPudlo]

Hey Alexian, 

as per my knowledge, if you are using standard SQL, you can use function DATE(timestamp_expression[timezone]) for converting timezones in BQ.

SELECT DATETIME("2018-02-22 10:27:00+01", "America/Los_Angeles") as date;

Hope this is going to help. 

[Alexian]

Thanks!!

However above statement is not extracting time_zone hour. 

[BartPudlo]

Got it! Then I think we don't have any equivalent in BigQuery.