| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vivek Khera | 2002-02-21 14:36:21 | Re: [GENERAL] schema error upgrading from 7.1 to 7.2 |
| Previous Message | Paul Rowland | 2002-02-21 12:37:07 | Re: Trying Cygwin version of PostgreSQL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brian Knox | 2002-02-21 14:14:17 | Re: comparision chart |
| Previous Message | Troels Arvin | 2002-02-21 13:47:12 | Re: comparision chart |