From: | Carlos Henrique Reimer <carlos(dot)reimer(at)opendb(dot)com(dot)br> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | to_date function |
Date: | 2010-07-07 21:07:04 |
Message-ID: | AANLkTinljUkkDJp8vjknaMoONMPfsYRa9ibCQxkeCVpr@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
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?
Thank you in advance!
template1=# select to_date('01/04/2013 23:59:59','DD/MM/YYYY
HH24:Mi:SS') ;
to_date
------------
2009-04-01
(1 row)
template1=# select to_date('01/04/2013 23:59:59','DD/MM/YYYY HH24:mi:SS')
;
to_date
------------
2013-04-01
(1 row)
template1=# select to_date('01/04/2013 23:59:59','DD/MM/YYYY HH24:mI:SS')
;
to_date
------------
2009-04-01
(1 row)
template1=# select to_date('01/04/2013 23:59:59','DD/MM/YYYY
hH24:MI:SS') ;
to_date
------------
2013-04-01
(1 row)
--
Reimer
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2010-07-07 21:31:04 | Anyone in Madison? |
Previous Message | Chris Browne | 2010-07-07 19:20:31 | Re: Want to schedule tasks for the future |