| From: | Tim Landscheidt <tim(at)tim-landscheidt(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: to_date function |
| Date: | 2010-07-07 21:38:37 |
| Message-ID: | m3sk3vgeg2.fsf@passepartout.tim-landscheidt.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Carlos Henrique Reimer <carlos(dot)reimer(at)opendb(dot)com(dot)br> wrote:
> I've a Linux box running postgresql 8.2.17 and facing some strange results
> from the to_date function.
> As you can see in the following tests the problem occurs when the template
> used includes upper and lower case characters for the minute (Mi or mI).
> Am I using the incorrect syntax or is it a bug?
> [...]
In general, the template patterns are case-sensitive (cf.
"month" vs. "Month" vs. "MONTH"). So "mI" will probably be
interpreted as a literal "m" and "I" meaning "last digit of
ISO year" which isn't what you want.
So use "MI" and be happy.
Tim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ludwig Kniprath | 2010-07-07 21:40:33 | Re: to_date function |
| Previous Message | Josh Berkus | 2010-07-07 21:31:04 | Anyone in Madison? |