Re: Snapshot refresh

From: David Turner <turner_at_tellme.com>
Date: Mon, 07 Aug 2000 10:56:43 -0700
Message-Id: <10582.113991@fatcity.com>

Actually the date statement is not what I was curious about. It was more about the start with and next parm. The statement I gave will work because of the order of precedence. Multiplication will always take place before addition. However, yours is easier to read.

  1* select to_char(trunc(sysdate)+ 2.5/24 +1,'YY-MON-DD:HH24:MI:SS') from dual

SQL> / TO_CHAR(TRUNC(SYSD

---

00-AUG-08:02:30:00 SQL> host date
Mon Aug 7 10:30:40 PDT 2000

The snapshot is refreshing at 2:30 each day.

                                                                Thanks anyway,

Dave

dgoulet_at_vicr.com wrote:

> Dave,
>
> Try "next trunc(sysdate+1)+(2.5/24)". What your statement is saying is
> "trunc(sysdate)+2:30+1" or 3:30 AM today.
>
> ____________________Reply Separator____________________
> Subject: Snapshot refresh
> Author: David Turner <turner_at_tellme.com>
> Date: 8/4/00 5:05 PM
>
> I am drawing a blank, maybe it's my cel phone:)
>
> I want to have a snapshot refresh every morning at 2:30 am. Here is what
> I think
> will work
>
> refresh start with trunc(sysdate)+ 2.5/24 +1
> next trunc(sysdate)+ 2.5/24 +1
>
> But I would like someone else to make a suggestion if I am wrong. Any
> help is appreciated.
>
> Thanks,
> Dave Turner
>
> --
> Author: David Turner
> INET: turner_at_tellme.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Aug 07 2000 - 12:56:43 CDT