diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-08 08:11:53 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-08 08:12:02 +0000 |
| commit | 8d36f5966675e23bee7026ba37ae0647fbf47300 (patch) | |
| tree | df4227bbb3b07cb70df87237bcff03c8efd7822d /sqlglot/dialects/oracle.py | |
| parent | Releasing debian version 22.2.0-1. (diff) | |
| download | sqlglot-8d36f5966675e23bee7026ba37ae0647fbf47300.tar.xz sqlglot-8d36f5966675e23bee7026ba37ae0647fbf47300.zip | |
Merging upstream version 23.7.0.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'sqlglot/dialects/oracle.py')
| -rw-r--r-- | sqlglot/dialects/oracle.py | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/sqlglot/dialects/oracle.py b/sqlglot/dialects/oracle.py index bccdad0..e038400 100644 --- a/sqlglot/dialects/oracle.py +++ b/sqlglot/dialects/oracle.py @@ -9,6 +9,7 @@ from sqlglot.dialects.dialect import ( build_formatted_time, no_ilike_sql, rename_func, + to_number_with_nls_param, trim_sql, ) from sqlglot.helper import seq_get @@ -246,6 +247,7 @@ class Oracle(Dialect): exp.TemporaryProperty: lambda _, e: f"{e.name or 'GLOBAL'} TEMPORARY", exp.TimeToStr: lambda self, e: self.func("TO_CHAR", e.this, self.format_time(e)), exp.ToChar: lambda self, e: self.function_fallback_sql(e), + exp.ToNumber: to_number_with_nls_param, exp.Trim: trim_sql, exp.UnixToTime: lambda self, e: f"TO_DATE('1970-01-01', 'YYYY-MM-DD') + ({self.sql(e, 'this')} / 86400)", |