Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Oracle query with systimestamp returns object instead of string

Description

<cfquery>
SELECT systimestamp AS db_time FROM dual
</cfquery>

Result - see Screenshot

Environment

All

Attachments

1
  • 14 Dec 2016, 04:04 pm

Activity

Show:

Pothys - MitrahSoft 15 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

Fixed

Details

Assignee

Reporter

Priority

Labels

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

Affects versions

Created 14 December 2016 at 16:04
Updated 6 January 2017 at 00:26
Resolved 4 January 2017 at 07:07

Flag notifications