Re: Arithmetic on DATE type

mbobak_at_tr1106.to.ford.com (Mark J. Bobak) writes:

>In article <d7hansl.773681116_at_dtek.chalmers.se>,
>Hans Lindberg <d7hansl_at_dtek.chalmers.se> wrote:
>>Are there any nice functions that operate on DATE type variables?
>>I'd like to be able to for example add one day to a certain date.
>>Adding " to_date('24','HH24') " doesn't work as " + " doesn't accept
>>date type operands. Do I have to convert it to a string and manipulate
>>it the hard way? Are there any PD librarys around on the net?
 

>Hmmm.....either you're overlooking the obvious, or I'm missing what you're
>trying to do. Here are some examples of what I *think* you want to do:
 

>first, today's date:
 

>SQL*Plus> select sysdate from dual;
>
>SYSDATE
>---------
>08-JUL-94
 
>Add a day for tomorrow,
 

>SQL*Plus> select sysdate + 1 from dual;
>
>SYSDATE+1
>---------
>09-JUL-94
--further examples deleted

Sigh, yep I guess I did overlook the sort of obvious, I'm sort of green... I believe I tried to add two date values, which I believe failed... well, anyway...

Is there a oracle-ftp server with info, updates etc?

Thanks for responding,
Hans Lindberg Tel: 031-183151 EMail d7hansl_at_dtek.chalmers.se Gullspaangs Kraft AB Karlstad

    /      /    /	"-Fashion is a form of ugliness so intolerable
   /      /    /	 that we have to alter it every six months."
  /------/    /
 /      /    /				--Oscar Wilde
/      /    /.....
---------------------------------------------------------------------------