How to link the system date in a ShowCase query date condition, so that it will give the current information every time it is run.


Use the Current TimeStamp Function within Query.

CURRENT TIMESTAMP - This special register returns the date and time on the target data source when the SQL statement runs.


Compatibility - This is a server-specific special register and should not be used when you need a portable query that can be run against data sources other than an iSeries. The ODBC equivalent to this special register is the function NOW.

Returns - A timestamp value that is based on a reading of the time-of-day clock when the SQL statement runs. If this function is used more than once within a single SQL statement or is used with the CURTIME, CURDATE, CURRENT DATE, CURRENT TIME or NOW functions, all values are based on a single clock reading.


Ref#: 1477219





Still have questions? We can help. Submit a case to technical support

Last Modified On:
You don't have the appropriate permissions.
No, open a new Support Case