Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Add day/hour/half-hour to given date in PL/SQL
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