display TIMESTAMP(6) WITH LOCAL TIME ZONE in original timestamp
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;