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
[cid:[email protected]]
Regards,
Noam
Information in this e-mail and its attachments is confidential and privileged
under the TEOCO confidentiality terms that can be reviewed
here<http://www.teoco.com/email-disclaimer>.