Re: dbms_jobs once an hour at the bottom of the hour

"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:4382157f$0$4360$626a54ce_at_news.free.fr...
> | >
> | > dbms_job.submit (..., next_date=>trunc(sysdate,'HH')+3/24/2,
> | > interval=>'trunc(sysdate,''HH'')+3/24/2',...);
> | >
> | > Regards
> | > Michel Cadot
> | >
> | >
> |
> | How did you come up with this?
> | I see the trunc(sysdate,'HH') comes up with the current hour but the
> 3/24/2
> | is a mystery to me.
> |
> |
>
> Well, 1 is a day, 1/24 is one hour, 3/24/2 is 1.5 hour.
> So truncating to the hour and adding 1.5 hour give me
> 30 minutes after the next hour.
>

Bonjour Michel

Would you also have a clever way of getting the time that would represent the next half hour?
I can't find a way...
1:00, then 1:30, then 2:00, 2:30, etc for running a job every 30 minutes.

Thanks
Syltrem

> Regards
> Michel Cadot
>
>
Received on Tue Nov 22 2005 - 08:04:08 CST