Skip to:

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

Default timezone for cfquery

Description

My timezone setting on the OS and database is PST, and Lucee is PST8PDT. However, Lucee seems to be converting my database timestamps to UTC. The database contains data with the correct timestamp; for example, 6/11/2015 14:54:50. However, when doing a cfquery(SELECT) the timestamp returned isn't correct; for example, {ts '2015-06-11 22:54:50'}. I've also attempted changing the datasource timezone from 'Same as Lucee instance' to 'PST8PDT'.

This is a major problem if timestamps from the database are auto converted. Is anyone else facing this issue? Is there a workaround/setting that I'm missing?

Environment

OS: Windows Server 2008 R2 SP1 - timezone PST
Database: Teradata 15.0 - timezone PST
Datasource: Other JDBC Driver
Lucee Locale: English (United States)
Lucee Server and Web instances - timezone "PST8PDT - Pacific Standard Time"

Activity

Show:

Michael Offner 1 December 2016 at 10:01

for lucee 5 we added a datasource driver for Teradata (that driver also can be used for Lucee 4.5) that can be downloaded here
http://stable.lucee.org/download/?type=extensions
or in the admin.
That driver tells Lucee to add timezone offset to the ansi string date, that way teradata get the right timezone for the date.

Michael Offner 1 December 2016 at 09:59

this is related to teradata, an ansi formated string date passed for example as follows:

<cfquery> select #now()# as n </cfquery>

is interpreted as UTC date.

Priya Jayaprakash 23 June 2015 at 23:07

Can someone provide some assistance on how to perform a cfquery(SELECT) so the correct timestamp is retrieved/displayed (ie. 6/11/2015 14:54:50)? This is a major blocker for me. Thanks!

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

Affects versions

Created 11 June 2015 at 22:40
Updated 1 December 2016 at 10:40
Resolved 1 December 2016 at 10:40

Flag notifications