Skip site navigation (1) Skip section navigation (2)

Re: Dates and year 2000

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: Andy Marden <amarden(at)usa(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Dates and year 2000
Date: 2002-02-21 14:13:52
Message-ID: 3C7500A0.72221DCD@fourpalms.org (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-sql
> 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

In response to

pgsql-bugs by date

Next:From: Vivek KheraDate: 2002-02-21 14:36:21
Subject: Re: [GENERAL] schema error upgrading from 7.1 to 7.2
Previous:From: Paul RowlandDate: 2002-02-21 12:37:07
Subject: Re: Trying Cygwin version of PostgreSQL

pgsql-sql by date

Next:From: Brian KnoxDate: 2002-02-21 14:14:17
Subject: Re: comparision chart
Previous:From: Troels ArvinDate: 2002-02-21 13:47:12
Subject: Re: comparision chart

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group