Specifying relative time comparisons on UNIX
The getdate
function is an ObjectServer
SQL function that returns the current date and time. You can use this
function in a calculation to establish a time relative to the present.
About this task
The calculation is made in seconds, so 300
represents
300 seconds or 5 minutes. For example, to retrieve events that occurred
within the last 10 minutes, you can type:
getdate - 600
Note that spaces are required on either side of the minus (-) sign.
The following figure shows the type of
fields that are displayed for relative time values in the element
definition area of the UNIX Filter
Builder. To specify a time that is relative to the current time, select Relative from
the drop-down list (below the Operator field),
and then type the appropriate getdate
calculation
in the adjacent field.