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,
Tom Lane wrote:
Luca Clementi <[EMAIL PROTECTED]> writes:
It seems that the to_timestamp does not work properly in this case,
when it comes to parsing the hours.
to_timestamp() is not very robust if the input doesn't exactly match
what it expects for the format string. I'm no
So the start_time is a varchar column, which contains a date.
opal_app=# select job_id,start_time from job_status where
job_id='app1201551799779' ;
job_id |start_time
--+--
app1201551799779 | 1 28, 2008 12:23:19 午後
(1 row)
o