Add time to a date?

Question

question

user-91 (google) asked Jan 25, '10

Hi,

Is there a way to add a certain amount of time to a date, something similar to this:

add_time(date_col, '23:59:59')

sql time

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-01-25T10:35:16Z

Andrew Mobbs answered Jan 25, '10

Just add a number. Each day is 1, so to add an hour:

SELECT sysdate+1/24 FROM dual;

or a minute:

SELECT sysdate+1/1440 FROM dual;

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.