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.


My steps

·         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








Information in this e-mail and its attachments is confidential and privileged under the TEOCO confidentiality terms that can be reviewed here.