TIMESTAMPVAL and DATEVAL functions in SELECT clause in executesql do not work
Operating system version
Description of the issue
Attempting to use DATEVAL and TIMESTAMPVAL in Select clause of select statement within EXECUTESQL function. Neither are recognized as executesql returns a '?'.
Where z_ten is a table contains 10 rows.
select current_date, current_timestamp, current_time
does execute correctly
Steps to reproduce the problem
Enter the above two queries in a simple test harness.
The value '2012-01-01' repeated ten times