Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Add day/hour/half-hour to given date in PL/SQL

Re: Add day/hour/half-hour to given date in PL/SQL

From: Murali Kazhipurath <murali_at_jps.net>
Date: Sun, 29 Nov 1998 02:29:17 -0800
Message-ID: <3661229f.0@blushng.jps.net>


To add a day, add 1 to the date.

To add an hour, add 1/24 to a date.

To add half hour, add 1/48 to a date.

Juergen Schneider wrote in message <73pjhk$3fm_at_news.netcologne.de>...
>Hi,
>
>how I can I add a day/hour/half-hour to a given date variable in PL/SQL. Is
>this possible ?
>
>TIA,
>
>// Juergen
>
>
Received on Sun Nov 29 1998 - 04:29:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US