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.
Syntax - CURRENT TIMESTAMP
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.
Still have questions? We can help. Submit a case to Technical Support.