feat(postgres): Parse TO_DATE as exp.StrToDate (#3799)

VaggelisD · web-flow · commit a6d84fbd9b41 · 2024-07-23T20:39:54.000+03:00
diff --git a/sqlglot/dialects/postgres.py b/sqlglot/dialects/postgres.py
@@ -365,6 +365,7 @@ class Parser(parser.Parser):
             "NOW": exp.CurrentTimestamp.from_arg_list,
             "REGEXP_REPLACE": _build_regexp_replace,
             "TO_CHAR": build_formatted_time(exp.TimeToStr, "postgres"),
+            "TO_DATE": build_formatted_time(exp.StrToDate, "postgres"),
             "TO_TIMESTAMP": _build_to_timestamp,
             "UNNEST": exp.Explode.from_arg_list,
             "SHA256": lambda args: exp.SHA2(this=seq_get(args, 0), length=exp.Literal.number(256)),
diff --git a/tests/dialects/test_postgres.py b/tests/dialects/test_postgres.py
@@ -759,6 +759,14 @@ def test_postgres(self):
             },
         )
 
+        self.validate_all(
+            "SELECT TO_DATE('01/01/2000', 'MM/DD/YYYY')",
+            write={
+                "duckdb": "SELECT CAST(STRPTIME('01/01/2000', '%m/%d/%Y') AS DATE)",
+                "postgres": "SELECT TO_DATE('01/01/2000', 'MM/DD/YYYY')",
+            },
+        )
+
     def test_ddl(self):
         # Checks that user-defined types are parsed into DataType instead of Identifier
         self.parse_one("CREATE TABLE t (a udt)").this.expressions[0].args["kind"].assert_is(
