Does this work for you:
select trunc(sysdate + 1/24,'hh') + 50/(60 * 24)from dual;
Your next will be: 'trunc(sysdate + 1/24,'hh') + 50/(60 * 24)'
Regards,
Waleed
-Original Message-
Sent: Friday, January 10, 2003 9:09 PM
To: Multiple recipients of list ORACLE-L
Stephane:
Precisely
Stephane:
Precisely what I was after!
Thanks so much for your help. I really appreciate it.
Barb
--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> Barbara Baker wrote:
> >
> > Sun / Solaris 2.6 ; Oracle RDBMS v8.0.5.2.1
> >
> > List:
> > I want to change the perfstat statspack.snap
> procedu
Barbara Baker wrote:
>
> Sun / Solaris 2.6 ; Oracle RDBMS v8.0.5.2.1
>
> List:
> I want to change the perfstat statspack.snap procedure
> FROM running every hour on-the-hour
> TO running at 10 minutes till the hour.
> (On-the-hour is conflicting with another procedure.)
> I tried to Read
Sun / Solaris 2.6 ; Oracle RDBMS v8.0.5.2.1
List:
I want to change the perfstat statspack.snap procedure
FROM running every hour on-the-hour
TO running at 10 minutes till the hour.
(On-the-hour is conflicting with another procedure.)
I tried to Read The Frustrating Manual, but I can o