Re: Adding time to existing Date field

From: Nandakumar <nanban_at_my-deja.com>
Date: Wed, 11 Aug 1999 17:42:33 GMT
Message-ID: <7oscm5$ico$1@nnrp1.deja.com>

I guess Sybrand actually means,
date_field := date_field + (80/(24 * 60 ))

Eg.
select to_char(sysdate,'DD/MM/YYYY HH:MI:SS'), to_char(sysdate+80/(24*60),'DD/MM/YYYY HH:MI:SS') from dual

Ans:
11/08/1999 01:41:41 11/08/1999 03:01:41

In article <934314670.20885.0.pluto.d4ee154e_at_news.demon.nl>, "Sybrand Bakker" <postmaster_at_sybrandb.nospam.demon.nl> wrote:
> date_field := date_field + (80/(24 * 60 * 60))
> It's that easy.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> premjit <premjit_at_hq.idt.net> wrote in message
> news:7opujg$goi_at_nnrp3.farm.idt.net...
> > 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
> >
> >
> >
>
>

--
Nandakumar
Systems Analyst
New York
(N.Kumar_at_rocketmail.com)

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Aug 11 1999 - 12:42:33 CDT