| From: | Brendan Jurd <direvus(at)gmail(dot)com> |
|---|---|
| To: | marc(at)bloodnok(dot)com |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org, Steve Crawford <scrawford(at)pinpointresearch(dot)com>, pgsql-general(at)postgresql(dot)org, hackers(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] Date conversion using day of week |
| Date: | 2011-03-31 16:07:07 |
| Message-ID: | AANLkTim9EPs4VaTVSUkWGOC2RJPyxSj0x_+9ybHhHCBB@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On 1 April 2011 02:35, Marc Munro <marc(at)bloodnok(dot)com> wrote:
> Just to be clear, the reason I was mixing things in this way was that I
> wanted to validate that the dayname being passed was valid for the
> current locale, and I could find no easier way of doing it.
Ah, I see. In that case I think to_date would have disappointed you
even if IYYY-IW-DY did work, since the inputs do not appear to be
checked against the localised versions of the day names. They are
only checked against the hard-coded English names. to_date and
to_char are asymmetric in this sense -- localisation only happens on
the way out.
Cheers,
BJ
| From | Date | Subject | |
|---|---|---|---|
| Next Message | salah jubeh | 2011-03-31 16:19:08 | stack depth limit exceeded |
| Previous Message | Marc Munro | 2011-03-31 15:35:23 | Re: [HACKERS] Date conversion using day of week |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2011-03-31 16:07:32 | Re: Problem with pg_upgrade? |
| Previous Message | Kevin Grittner | 2011-03-31 16:06:30 | Re: SSI bug? |