Manipulating current date and time

EQL provides four constant keywords to obtain current date and time values. Values are obtained at an arbitrary point during query evaluation.

GMT time and date are independent of any daylight savings rules, while System time and date are subject to daylight savings rules.

Keyword	Description
`CURRENT_TIMESTAMP`	Obtains current date and time in GMT.
`SYSTIMESTAMP`	Obtains current date and time in server time zone.
`CURRENT_DATE`	Obtains current date in GMT.
`SYSDATE`	Obtains system date in server time zone.

Note:

CURRENT_DATE and SYSDATE return dateTime data types where time fields are reset to zero.

The following example retrieves the average duration of service:

RETURN Example AS
SELECT AVG(CURRENT_DATE - DimEmployee_HireDate) AS DurationOfService
FROM EmployeeState
GROUP