Issues
3 of 3
Oracle query with systimestamp returns object instead of string
Fixed
Description
Environment
All
Attachments
1
Details
Assignee
Michael OffnerMichael OffnerReporter
Harry KleinHarry KleinPriority
CriticalLabels
Fix versions
New Issue warning screen
Before you create a new Issue, please post to the mailing list first https://dev.lucee.org
Once the issue has been verified, one of the Lucee team will ask you to file an issue
Sprint
NoneAffects versions
Details
Details
Assignee
Michael Offner
Michael Offner
Reporter
Harry Klein
Harry Klein
Priority
CriticalLabels
Fix versions
New Issue warning screen
Before you create a new Issue, please post to the mailing list first https://dev.lucee.org
Once the issue has been verified, one of the Lucee team will ask you to file an issue
Sprint
None
Affects versions
Created 14 December 2016 at 16:04
Updated 6 January 2017 at 00:26
Resolved 4 January 2017 at 07:07
Activity
Pothys - MitrahSoft15 December 2016 at 13:41
I've analyzed this ticket a lot & confirmed the issue happening on latest version of lucee. ACF11 returns the timestamp string, but lucee gives a class of oracle.sql.TIMESTAMPTZ. I've added the test cases for this too.
Pull request: https://github.com/lucee/Lucee/pull/138
<cfquery>
SELECT systimestamp AS db_time FROM dual
</cfquery>
Result - see Screenshot