Link the System Date in a Showcase Query Date Condition

 

Problem

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.

Solution

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.

Ref#: 1477219