My database time zone is '+06:00';
CREATE TABLE Table1
(
EMP_ID VARCHAR2(3 BYTE) NOT NULL,
CHANGED TIMESTAMP(6) WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP NOT NULL
)
When I do the following insert query from Toad
Insert Into Table1(EMP_ID ) values('ABC');
I got that inside Table1 table, chagned column the value is : 2/10/2016 5:54:47.885000 PM +06:00.
But if I use sql developer to execute the insert into query then the value become : 2/10/2016 5:54:47.885000 PM ASIA/DHAKA
Can anybody explain why this is happening.
For me it is necessary that the value will always show the time offset not the Zone info.