Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Condition
"___cliff rayman___" <cliff_at_SPAMMER_GO_HOME_rayman.com> a écrit dans le message de news: _Cl1f.573$k77.130_at_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
| ______________________________________________________
Not really: "load+1/24" verifies the condition but not your sentence.
Regards
Michel Cadot
Received on Fri Oct 07 2005 - 01:03:26 CDT