Oracle to bigquery

[G33K507]

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]

[tobymao]

you'll need to make a mapping in dialects/oracle.py that maps the function "TO_DATE" to exp.StrToDate

[G33K507]

Ok got it, Thanks 👍🏻