Bad Docs example
От | Rod Taylor |
---|---|
Тема | Bad Docs example |
Дата | |
Msg-id | 006101c1a47f$577d5d00$8001a8c0@jester обсуждение исходный текст |
Ответы |
Re: Bad Docs example
|
Список | pgsql-hackers |
time '05:00' + interval '2 hours' <== Shown below beside the '-' Name. date '2001-09-28' + interval '1 hour' <== also shown beside the '-' Name. The results look appropriate however, so flipping the +'s to -'s should be enough. Table 4-16. Date/Time Operators Name Example Result + timestamp '2001-09-28 01:00' + interval '23 hours' timestamp '2001-09-29 00:00' + date '2001-09-28' + interval '1 hour' timestamp '2001-09-28 01:00' + time '01:00' + interval '3 hours' time '04:00' - timestamp '2001-09-28 23:00' - interval '23 hours' timestamp '2001-09-28' - date '2001-09-28' + interval '1 hour' timestamp '2001-09-27 23:00' - time '05:00' + interval '2 hours' time '03:00' - interval '2 hours' - time '05:00' time '03:00:00' * interval '1 hour' * int '3' interval '03:00' / interval '1 hour' / int '3' interval '00:20' -- Rod Taylor Your eyes are weary from staring at the CRT. You feel sleepy. Notice how restful it is to watch the cursor blink. Close your eyes. The opinions stated above are yours. You cannot imagine why you ever felt otherwise.
В списке pgsql-hackers по дате отправления: