Skip to content

No conversion on Date functions when going from SQL Server to PostgreSQL. #6220

Description

@Hal-H2Apps

Fully reproducible code snippet

import sqlglot
sql=sqlglot.parse_one('SELECT DAY(FieldDate) FROM t', read='tsql')
sql.sql(dialect='postgres')

Results:
'SELECT DAY(FieldDate) FROM t'

Expected results:
'SELECT EXTRACT(DAY FROM FieldDate) FROM t'

Official Documentation
https://www.postgresql.org/docs/18/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions