pg.ddx.io pgsql-docs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Error in to_timestamp() example 2+ messages / 2 participants [nested] [flat]
Commits from this thread: 2016-12-29 f7e7d6fcef 4191b9ece4 ea853db4a5 49832227b2 ce15751eed Fix incorrect example of to_timestamp() usage.
* Error in to_timestamp() example @ 2016-12-29 17:00 michaelrush@gmail.com 0 siblings, 1 reply; 2+ messages in thread From: michaelrush@gmail.com @ 2016-12-29 17:00 UTC (permalink / raw) To: pgsql-docs 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Error in to_timestamp() example @ 2016-12-29 23:08 Tom Lane <tgl@sss.pgh.pa.us> parent: michaelrush@gmail.com 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2016-12-29 23:08 UTC (permalink / raw) To: michaelrush@gmail.com; +Cc: pgsql-docs 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2016-12-29 23:08 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2016-12-29 17:00 Error in to_timestamp() example michaelrush@gmail.com 2016-12-29 23:08 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox