Hi Michael,
The current code for query compiler maps all of these functions to
Expression#currentDateDate(). Some databases(for example derby)
distinguish between a TIMESTAMP type and DATE type.
For example the attached program which tries to update a TIMESTAMP field
on derby using "Update Employee e set e.testTimeStamp =
CURRENT_TIMESTAMP" generates sql "UPDATE EMPLOYEE_TBL SET TESTTIMESTAMP
= CURRENT DATE" which is not accepted by Derby. It is obvious that we
will need to map this functions to different expressions
Tom,
From javadocs in Expression.java, it seems that CURRENT_DATE should be
mapped to Expression#currentDateDate() (ExpressionOperator.currentDate)
and CURRENT_TIMESTAMP should be mapped to Expression#currentDate()
(ExpressionOperator.Today) . Is that correct?
Thanks,
Mitesh