SQL Condition

[Guest]

What is this condition meaning?

(TRUNC( MOD( ( SYSDATE- load )*24, 24 ) ) > 0 OR TRUNC( MOD(
(SYSDATE- load )*24*60, 60 ) ) > 30)

Thanks,
Kiran

[Maxim Demenko]

krallabandi@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

[FredBear]

"Maxim Demenko" <mdemenko@gmail.com> a écrit dans le message de news: di3v4k$i8d$00$1@news.t-online.com...
| krallabandi@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

[Maxim Demenko]

Michel Cadot schrieb: "Maxim Demenko" <mdemenko@gmail.com> a écrit dans le message de news: di3v4k$i8d$00$1@news.t-online.com... | krallabandi@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

[FredBear]

"Maxim Demenko" <mdemenko@gmail.com> a écrit dans le message de news: di43t6$cfq$02$1@news.t-online.com...
| Michel Cadot schrieb:
| > "Maxim Demenko" <mdemenko@gmail.com> a écrit dans le message de news: di3v4k$i8d$00$1@news.t-online.com...
| > | krallabandi@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