Re: SQL Condition

krallabandi_at_pharmacare.com schrieb am 06.10.2005 in <1128624468.906104.167260_at_o13g2000cwo.googlegroups.com>:

> What is this condition meaning?

> (TRUNC( MOD( ( SYSDATE- load )*24, 24 ) ) > 0 OR TRUNC( MOD(
> (SYSDATE- load )*24*60, 60 ) ) > 30)
Don't know what for but
(TRUNC( MOD( ( SYSDATE- load )*24, 24 ) ) > 0 means
false, if Sysdate is within the same hour of day of load (x is an integer)
(trunc(mod(X)*24,24)) = 0
trunc(mod(X+1/24)*24,24)) = 1
trunc(mod(X+1/23)*24,24)) = 23

find out the second term by yourself ;)

> Thanks,
> Kiran

Andreas

-- 
wenn email, dann AndreasMosmann <bei> web <punkt> de