I created a table with TIMESTAMP column and inserted a value from string to it. When I query the table I get the result with timezone offset – any way to avid it.
· I created a table DATE_TEST with TS column
· For insert I use: upsert into DATE_TEST values (to_Date('2014-09-01 11:00:00','yyyy-MM-dd HH:mm:ss')
· When calling select TO_CHAR (TS,'yyyy-MM-dd HH:mm:ss' ) from DATE_TEST I am getting the value that I inserted
· When claling select * from DATE_TEST I am getting the data with offset
See screen shout from I SQuirrel