Fix: Add postgres transpilation for TIME_TO_UNIX (#3305)

crericha · web-flow · commit d3472c664fdf · 2024-04-11T15:58:07.000-07:00
diff --git a/sqlglot/dialects/postgres.py b/sqlglot/dialects/postgres.py
@@ -510,6 +510,9 @@ class Generator(generator.Generator):
             exp.TsOrDsAdd: _date_add_sql("+"),
             exp.TsOrDsDiff: _date_diff_sql,
             exp.UnixToTime: lambda self, e: self.func("TO_TIMESTAMP", e.this),
+            exp.TimeToUnix: lambda self, e: self.func(
+                "DATE_PART", exp.Literal.string("epoch"), e.this
+            ),
             exp.VariancePop: rename_func("VAR_POP"),
             exp.Variance: rename_func("VAR_SAMP"),
             exp.Xor: bool_xor_sql,
diff --git a/tests/dialects/test_postgres.py b/tests/dialects/test_postgres.py
@@ -467,6 +467,12 @@ def test_postgres(self):
                 "tsql": "SELECT (CAST('2016-01-10' AS DATE), CAST('2016-02-01' AS DATE)) OVERLAPS (CAST('2016-01-20' AS DATE), CAST('2016-02-10' AS DATE))",
             },
         )
+        self.validate_all(
+            "SELECT DATE_PART('epoch', '2023-01-04 04:05:06.789')",
+            read={
+                "": "SELECT TIME_TO_UNIX('2023-01-04 04:05:06.789')",
+            },
+        )
         self.validate_all(
             "x ^ y",
             write={
