Skip to content
Advertisement

Translating Oracle Date Functions to BigQuery

I’m having trouble translating these Oracle date functions to BigQuery because BigQuery doesn’t allow such user-friendly additions to dates/timestamps. Any help is appreciated. Below are the two date functions in Oracle and my attempted (failed) versions in BigQuery:

Oracle:

BigQuery attempt:

Advertisement

Answer

You can use below for the first one

and for second – try below

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement