arsdate

[pankaj.puranik]

i have the following query which runs perfectly fine, meaning it gives me some results.
what does arsdate -1 imply?

arsdoc query -v -h ORSAPOH1-PHYS -u admin -p ondemand -f 'System Load' -i "where input_filename like '%%' and load_time between -1 and 1376989200"

[Alessandro Perucchi]

Hello Pankaj,

since the date in CMOD is a internal numerical representation of a date, AND since the number is between 0 and max(Integer), then a -1 means only that you are sure you get everything from before the day 0 :-D

Sincerely yours,
Alessandro

[LWagner]

Day 0 is January 1, 1970.

on the large value, it is the seconds from 01/01/1970 at midnight.
You can produce any midnight value in Excel using 86,400 * (date - 01/01/70)