Re: Adding time to existing Date field

date_field + 1/24 ---- adds one hour to the date field;

date_field + 1/(24*3) ---- adds 1/3 hour (20 minutes) to the date field.

Robert Xu, Oracle DBA
Caltech, Pasadena, CA

premjit (premjit_at_hq.idt.net) wrote:
: Hi,

: Can anyone let me know how to add say one hour and 20 minutes to the
: existing date field. The date field is fetched from the field in a table by
: PL/SQL.

: Thanks
Received on Tue Aug 10 1999 - 16:54:18 CDT