Re: Dates and year 2000 - Mailing list pgsql-bugs

From Thomas Lockhart
Subject Re: Dates and year 2000
Date
Msg-id 3C7500A0.72221DCD@fourpalms.org
Whole thread Raw
In response to Re: Dates and year 2000  ("Andy Marden" <amarden@usa.net>)
List pgsql-bugs
> Just discovered that column::date works fine but to_date(column, 'DD.MM.YY')
> causes the problem. I was trying to write portable SQL, but never mind!

Portable (as in SQL9x) would be

  cast(column as date)

which is also accepted by PostgreSQL...

                 - Thomas

pgsql-bugs by date:

Previous
From: Paul Rowland
Date:
Subject: Re: Trying Cygwin version of PostgreSQL
Next
From: Vivek Khera
Date:
Subject: Re: [GENERAL] schema error upgrading from 7.1 to 7.2