| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Belinda M(dot) Giardine" <giardine(at)bio(dot)cse(dot)psu(dot)edu>, Erik Jones <erik(at)myemma(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: date comparisons |
| Date: | 2006-12-12 17:58:17 |
| Message-ID: | 457EEDB9.8090903@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-patches |
Tom Lane wrote:
> "Belinda M. Giardine" <giardine(at)bio(dot)cse(dot)psu(dot)edu> writes:
>> Should it be this way?
>
> Well, to_timestamp() is apparently designed not to complain when the
> input doesn't match the format, which is not my idea of good behavior
> ... but your example is in fact wrong. 'Month' means a 9-character
> field, so you are short a couple of spaces.
The padding is on *input* too? Is this an Oracle compatibility "feature"?
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma Jr | 2006-12-12 18:13:04 | Re: Are updateable view as a linked table in ms-access a bad idea? |
| Previous Message | Tom Lane | 2006-12-12 17:55:40 | Re: date comparisons |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2006-12-12 21:24:12 | psql commandline conninfo |
| Previous Message | Tom Lane | 2006-12-12 17:55:40 | Re: date comparisons |