Re: SQL Condition

From: ___cliff rayman___ <cliff_at_SPAMMER_GO_HOME_rayman.com>
Date: Fri, 07 Oct 2005 03:06:34 GMT
Message-ID: <_Cl1f.573$k77.130@tornado.socal.rr.com>

krallabandi_at_pharmacare.com wrote:

>What is this condition meaning?
>
>(TRUNC( MOD( ( SYSDATE- load )*24, 24 ) ) > 0 OR TRUNC( MOD(
>(SYSDATE- load )*24*60, 60 ) ) > 30)
>
>

greater than a day or greater than 30 hours.

-- 
_____cliff_rayman_____________________________________
Business Consulting and Turnaround Management
[web] http://www.rayman.com/
[web] http://all-clear-turnaround-management.com/
[eml] cliff   _at__  rayman.com
[phn] 888-736-3802 x701
[fax] 818-743-7404
______________________________________________________

Received on Thu Oct 06 2005 - 22:06:34 CDT