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.

Figure 1. Element definition area for relative time values on UNIX
This figure shows the fields that are used for specifying relative time values in the UNIX Filter Builder.