dbms_job.submit versus dbms_job.isubmit plus date/time foramts

From: David Martin <djmartin_at_netspace.net.au>
Date: 1997/10/16
Message-ID: <34458393.12525596@news.netspace.net.au>#1/1

I am running on Windows 95 and Unix on a Sequent box using:

Oracle7  7.2.3.0.0
SQL*PLUS 3.3.2.0.2
PL/SQL   2.2.3.0.0

NLS-DATE-FORMAT DD-MON-RRRR (PC only, but is kept by dbms_job)

If I use an 'interval' (or 'next_date') similar to the following:

'to_date(next_day(sysdate,''THURSDAY'') || ''06:00 PM'',''dd-mon-yyyy
hh12:mi am'')'

(this runs a job every Thursday at 6pm local time) and use the
'submit' call, everything works okay. If I use 'isubmit', then the
time is set to 00:00:00.

Has anyone else had this problem??

David

---

 _--_|\     PO Box 139, Belair, South Australia, 5052
/      \    Tel:+61 3 5173-2273 Fax:+61 3 5173-2991
\_.-*._/    email: djmartin at netspace.net.au (Work things)
    ^ v          : davidj at adam.com.au (Adelaide stuff)
    |       "Don't fight the decision, fight its basis!"

    '----<---<---<---<---<---<---<---<---<---<---<---<---<---<- Received on Thu Oct 16 1997 - 00:00:00 CDT