Product specifications

Accessing 800xA via OLE DB
3BDS011222-510 B 473
Similarly, if you write, “MO-1D+5h”, then the start time is 5 a.m. on the last day of
the previous month, “NOW-1H15M” is one hour and fifteen minutes ago, and
“YEAR+3MO” is the first timestamp of April 1 this year.
Table 27. Description of the Keywords in the OPCHDA_TIME Format
Keyword Offset Description
NOW The current UTC time as
calculated on the server.
SECOND S The start of the current
second.
MINUTE M The start of the current minute.
HOUR H The start of the current hour.
DAY D The start of the current day.
WEEK W The start of the current week.
MONTH MO The start of the current month.
YEAR Y The start of the current year.
Table 28. Specification of the Offsets
Offset Description
S Offset from time in seconds.
M Offset from time in minutes.
H Offset from time in hours.
D Offset from time in days.
W Offset from time in weeks.
MO Offset from time in months.
Y Offset from time in years.