|
<< Click to Display Table of Contents >> CURRENT_DATE, CURRENT_TIMESTAMP, NOW() |
  
|
|
<< Click to Display Table of Contents >> CURRENT_DATE, CURRENT_TIMESTAMP, NOW() |
|
Though not included with the BDE Local SQL language, the PdxEditor handles both CURRENT_DATE and CURRENT_TIMESTAMP in SQL statements as included in most other implementations of the SQL language.
As an alternative to CURRENT_TIMESTAMP you may also include the more convenient short NOW() expression as used by e.g. MySQL, PostgreSQL, MS Access and MS Excel.
SQL using auto substituted PdxEditor constant CURRENT_DATE
These functions are among the most handy SQL features calculating date or time differences relative to the ever current date and allow storing SQL statements with these functions being up to date at whatever time being reloaded and executed.
PdxEditor manages by making use of on-the-fly substitution of the placeholder variables CURRENT_DATE, CURRENT_TIMESTAMP and NOW() with the ever current date or datetime constants into the US ShortDate ('MM/dd/yyyy') and US ShortDateTime ('MM/dd/yyyy hh:mm:ss') format respectively accepted by the BDE Local SQL SELECT statements without altering the written statement, and irrespective of the current regional date/datetime format.
Result of the auto substitution may be checked via the View SQL.