Oracle to bigquery
#883
Replies: 1 comment 1 reply
-
|
you'll need to make a mapping in dialects/oracle.py that maps the function "TO_DATE" to exp.StrToDate |
Beta Was this translation helpful? Give feedback.
1 reply
-
|
Ok got it, Thanks 👍🏻 |
Beta Was this translation helpful? Give feedback.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hi,
I am trying to convert Oracle SQL to bigquery using --sqlglot.transpile but it is not transforming the SQL code, in the output I am getting the Oracle SQL. PFB the code snippet below ---
sqlglot.transpile("SELECT TO_DATE('1970-01-01','YYYY-MM-DD') + (1618088028295 / 1000 / 86400)", read="oracle", write="bigquery")[0]
Beta Was this translation helpful? Give feedback.
All reactions