Re: SQL Condition

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 6 Oct 2005 22:40:35 +0200
Message-ID: <43458b98$0$6505$636a15ce_at_news.free.fr>


[Quoted] "Maxim Demenko" <mdemenko_at_gmail.com> a écrit dans le message de news: di3v4k$i8d$00$1_at_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 Received on Thu Oct 06 2005 - 22:40:35 CEST

Original text of this message