Re: [GENERAL] to_date function

2010-07-07 Thread Ludwig Kniprath
Hi, on a Windows/PostgrSQL 8.4 three from your queries throw errors (sorry, but they are in german): select to_date('01/04/2013 23:59:59','DD/MM/ HH24:Mi:SS'); => FEHLER: ungültige Kombination von Datumskonventionen HINT: Die Gregorianische und die ISO-Konvention für Wochendaten können n

Re: [GENERAL] to_date function

2010-07-07 Thread Tom Lane
Carlos Henrique Reimer writes: > 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

Re: [GENERAL] to_date function

2010-07-07 Thread Tim Landscheidt
Carlos Henrique Reimer 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

[GENERAL] to_date function

2010-07-07 Thread 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