Re: datetime addition/subtraction

In article <1fivpjINNrj2_at_gaia.ucs.orst.edu> mickel_at_OES.ORST.EDU (Paul M. Mickel) writes:
>
>Now, for my questions. How do I add times to a field?? What I want to do
>is take a "datetime" field in sqlforms30, add a certain number of hrs to
>it to generate a new datetime. Here is what has been tried:
>

select to_char(sysdate+1/24,'mm/dd/yy hh24:mi) from dual

Aniruddha Kortikar (kortikar_at_mipos2.intel.com)

E-mail 	: kortikar_at_mipos2.intel.com | A billion here, a billion there ...
Phone(W): 408 765 5515              | pretty soon it adds upto real money.
-------------------------------------------------------------------------------