Carlos Henrique Reimer <carlos.reimer@xxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
