[GENERAL] to_date function

[Carlos Henrique Reimer]

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