Re: SQL Condition

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Thu, 06 Oct 2005 21:49:43 +0200
Message-ID: <di3v4k$i8d$00$1_at_news.t-online.com>


[Quoted] 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 Received on Thu Oct 06 2005 - 21:49:43 CEST

Original text of this message