Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    464

    Unanswered: specifiying a time.....9i

    Hi

    I've only got one field to specify the time for a procedure to run. Currently I'm running it as:

    Code:
    TRUNC(sysdate, 'HH') + (1/24) + (15/24/60)
    So the proc runs at 15 min past the hour. But what if I want to run every 15 min like 30/24/60, 45/24/60......?

    Specifiying
    Code:
    sysdate+15/24/60
    will not necessarily run it at 15, 30, 45 min past the hour, right?

    Regards

  2. #2
    Join Date
    Aug 2008
    Posts
    464
    Just thought, could it be:

    TRUNC(SYSDATE,'MI')+(15/24/60) ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •