Error in to_timestamp() example

Started by Nonameover 9 years ago2 messagesdocs
Jump to latest
#1Noname
michaelrush@gmail.com

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.5/static/functions-formatting.html
Description:

In this example:

> Here is a more complex example: to_timestamp('15:12:02.020.001230',
'HH:MI:SS.MS.US') is 15 hours, 12 minutes, and 2 seconds + 20 milliseconds +
1230 microseconds = 2.021230 seconds.

HH needs to be HH24

> ERROR: hour "15" is invalid for the 12-hour clock
> HINT: Use the 24-hour clock, or give an hour between 1 and 12.

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#1)
Re: Error in to_timestamp() example

michaelrush@gmail.com writes:

In this example:

> Here is a more complex example: to_timestamp('15:12:02.020.001230',
'HH:MI:SS.MS.US') is 15 hours, 12 minutes, and 2 seconds + 20 milliseconds +
1230 microseconds = 2.021230 seconds.

HH needs to be HH24

You're right, thanks for reporting it.

regards, tom lane

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs