Merge "add backend agnostic UUID datatype" into main

2 files changed, 27 insertions, 3 deletions

diff --git a/lib/sqlalchemy/dialects/oracle/base.py b/lib/sqlalchemy/dialects/oracle/base.py
index 55d5a4fb5..37b81e1dd 100644
--- a/lib/sqlalchemy/dialects/oracle/base.py
+++ b/lib/sqlalchemy/dialects/oracle/base.py
@@ -690,7 +690,7 @@ class LONG(sqltypes.Text):
 
 
 class _OracleDateLiteralRender:
-    def literal_processor(self, dialect):
+    def _literal_processor_datetime(self, dialect):
         def process(value):
             if value is not None:
                 if getattr(value, "microsecond", None):
@@ -709,6 +709,25 @@ class _OracleDateLiteralRender:
 
         return process
 
+    def _literal_processor_date(self, dialect):
+        def process(value):
+            if value is not None:
+                if getattr(value, "microsecond", None):
+                    value = (
+                        f"""TO_TIMESTAMP"""
+                        f"""('{value.isoformat().split("T")[0]}', """
+                        """'YYYY-MM-DD')"""
+                    )
+                else:
+                    value = (
+                        f"""TO_DATE"""
+                        f"""('{value.isoformat().split("T")[0]}', """
+                        """'YYYY-MM-DD')"""
+                    )
+            return value
+
+        return process
+
 
 class DATE(_OracleDateLiteralRender, sqltypes.DateTime):
     """Provide the oracle DATE type.
@@ -723,12 +742,16 @@ class DATE(_OracleDateLiteralRender, sqltypes.DateTime):
 
     __visit_name__ = "DATE"
 
+    def literal_processor(self, dialect):
+        return self._literal_processor_datetime(dialect)
+
     def _compare_type_affinity(self, other):
         return other._type_affinity in (sqltypes.DateTime, sqltypes.Date)
 
 
 class _OracleDate(_OracleDateLiteralRender, sqltypes.Date):
-    pass
+    def literal_processor(self, dialect):
+        return self._literal_processor_date(dialect)
 
 
 class INTERVAL(sqltypes.NativeForEmulated, sqltypes._AbstractInterval):
diff --git a/lib/sqlalchemy/dialects/oracle/cx_oracle.py b/lib/sqlalchemy/dialects/oracle/cx_oracle.py
index 290789f32..fbac8b93e 100644
--- a/lib/sqlalchemy/dialects/oracle/cx_oracle.py
+++ b/lib/sqlalchemy/dialects/oracle/cx_oracle.py
@@ -580,7 +580,8 @@ class _CXOracleDate(oracle._OracleDate):
 
 
 class _CXOracleTIMESTAMP(oracle._OracleDateLiteralRender, sqltypes.TIMESTAMP):
-    pass
+    def literal_processor(self, dialect):
+        return self._literal_processor_datetime(dialect)
 
 
 # TODO: the names used across CHAR / VARCHAR / NCHAR / NVARCHAR