yql/essentials/tests/sql/suites/pg/dates_to_pg.sql


1
2
3
4
5
6
7

select ToPg(date("1970-01-01")),ToPg(date("2105-12-31")),
       ToPg(datetime("1970-01-01T00:00:00Z")),ToPg(datetime("2105-12-31T23:59:59Z")),
       ToPg(timestamp("1970-01-01T00:00:00.000000Z")),ToPg(timestamp("2105-12-31T23:59:59.999999Z")),
       ToPg(date32("-4714-11-24")),ToPg(date32("148107-12-31")),
       ToPg(datetime64("-4714-11-24T00:00:00Z")),ToPg(datetime64("148107-12-31T23:59:59Z")),
       ToPg(timestamp64("-4714-11-24T00:00:00.000000Z")),ToPg(timestamp64("148107-12-31T23:59:59.999999Z"));