Error in to_timestamp() example

From: michaelrush(at)gmail(dot)com
To: pgsql-docs(at)postgresql(dot)org
Subject: Error in to_timestamp() example
Date: 2016-12-29 17:00:43
Message-ID: 20161229170043.10139.21416@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2016-12-29 23:08:50 Re: Error in to_timestamp() example
Previous Message azopane 2016-12-29 14:33:54 start-up script for OpenBSD