| Lists: | pgsql-docs |
|---|
| 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: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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.
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | michaelrush(at)gmail(dot)com |
| Cc: | pgsql-docs(at)postgresql(dot)org |
| Subject: | Re: Error in to_timestamp() example |
| Date: | 2016-12-29 23:08:50 |
| Message-ID: | 28917.1483052930@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-docs |
michaelrush(at)gmail(dot)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