Need help translating this function to BigQuery from Oracle, the from_tz and timestamp formatting are giving me trouble:

trunc(from_tz(to_timestamp(trunc(llc.DATE) || ' ' || llc.HOUR, 'DD-MON-YY HH24MISS'), 'UTC') at time zone 'America/New_York') as the_date

CodePudding user response：

Consider the below approach. I used