Re: [SQL] Problem with the to_timestamp function

2008-01-31 Thread Tom Lane
Luca Clementi <[EMAIL PROTECTED]> writes: > What do you mean with th standard input converter, you mean casting that > string into a date with the default locate format. This won't work, > because the machine where the DB is running is set to en.US, so it won't > be able to parse that date. That

Re: [SQL] Problem with the to_timestamp function

2008-01-31 Thread Luca Clementi
Tom Lane wrote: Luca Clementi <[EMAIL PROTECTED]> writes: I found the problem!! to_timestamp(start_time, 'M DD, HH12:MI:SS') in the formatting string I have two spaces, while in the original there is only one: 1 28, 2008 12:23:19 �後 So if I use: 'M DD, HH12:MI:SS' as a formattin