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.