Skip to Main Content
Forums

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!

Timestamp with timezone offset 000

937454Oct 14 2013 — edited Oct 14 2013

Hi,

My db version is 11g

I created a table as"

create table t1 (col1 timestamp with time zone)

And using our custom etl process loaded data into t1. The source data is in GMT.

When I query t1 data, I see data in this format: 14-OCT-13 10.20.53.000000000 AM -05.00

I really dont want that -05.00 at the end.

I need to offset it by 0000. How can I do that.

What confuses me is, should I do it at create table. Or at insert into table. Please advice.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 11 2013
Added on Oct 14 2013
11 comments
1,161 views