Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

display TIMESTAMP(6) WITH LOCAL TIME ZONE in original timestamp

Sascha MonteiroSep 26 2011 — edited Sep 26 2011
Hi,
I have a table (in Oracle-XE 10) with a column (TIMESTAMP(6) WITH LOCAL TIME ZONE)
when entries are stored, a trigger will use sysdate to populate the field

Now I have an issue running a report that spans over the DST change, I need it to display the timestamp of how it was when it was inserted,
not how it looks like after the DST change.
(I probably should have used WITH TIMEZONE, but can't change it now as the table needs to be empty and records are inserted every few seconds 24/7)

Is there a query that could take of this?
I use this query now;
select r.emp_id as EMPLOYEEID,to_char(r.DATETIME,'YYYY-MM-DD HH24:MI:SS') AS RECTIME from time_log r order by r.datetime asc;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2011
Added on Sep 26 2011
5 comments
2,827 views