Re: SQL Condition

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Thu, 06 Oct 2005 23:11:05 +0200
Message-ID: <di43t6$cfq$02$1_at_news.t-online.com>


Michel Cadot schrieb:
> "Maxim Demenko" <mdemenko_at_gmail.com> a écrit dans le message de news: di3v4k$i8d$00$1@news.t-online.com...
> | krallabandi_at_pharmacare.com schrieb:
> | > What is this condition meaning?
> | >
> | > (TRUNC( MOD( ( SYSDATE- load )*24, 24 ) ) > 0 OR TRUNC( MOD(
> | > (SYSDATE- load )*24*60, 60 ) ) > 30)
> | >
> | > Thanks,
> | > Kiran
> | >
> |
> | This condition ensures that actual time is at least half an hour later
> | than the time of "load"
> |
> | Best regards
> |
> | Maxim
>
> Not really: "load+1455/1440" verifies your sentence but not the condition.
>
> Regards
> Michel Cadot
>
>

[Quoted] Maybe my wording was wrong, saying actual time , i meant only *time* ( i.e. today 15:30 is 20 min later than yesterday 15:10 or 15:10 one month ago). According this meaning , "load + 1455/1440" is only 15 min later than load, so it doesn't verify my sentence.

Best regards

Maxim Received on Thu Oct 06 2005 - 23:11:05 CEST

Original text of this message