Re: SQL Condition
Date: Fri, 7 Oct 2005 08:10:54 +0200
Message-ID: <43461142$0$7914$626a14ce_at_news.free.fr>
"Maxim Demenko" <mdemenko_at_gmail.com> a écrit dans le message de news: di43t6$cfq$02$1_at_news.t-online.com...
| Michel Cadot schrieb:
| > "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
| >
| >
|
| Maybe my wording was wrong, saying actual time , i meant only *time* (
| i.e. today 15:30 is 20 min later than yesterday 15:10 or 15:10 one month
| ago). According this meaning , "load + 1455/1440" is only 15 min later
| than load, so it doesn't verify my sentence.
|
| Best regards
|
| Maxim
Yes my understanding was time includes date (as in all timestamp or date Oracle datatypes or functions).
Regards
Michel Cadot
Received on Fri Oct 07 2005 - 08:10:54 CEST