« New features for high-view monitoring in IQ and ASE | Main | Getting the previous row or CROSS APPLY alternative for ASE »

03 July 2011


Feed You can follow this conversation by subscribing to the comment feed for this post.

Shyam Yadav

Hi Leonid,
I am Shyam Yadav from Mumbai. I work on Sybase Unwired Platform.
My problem is when I get data from Oracle and put it into Sybase (CDB i.e Cached Database) all the Table data with type TIMESTAMP are added with +05:30.

Please provide some solution as it is high priority task for me.

Thanks & Regards,
Shyam Yadav

Leonid Gvirtz

Hi Shyam

Are you sure that you don't use TIMESTAMP WITH TIME ZONE datatype instead of TIMESTAMP? For TIMESTAMP WITH TIME ZONE columns the observed behavior is expected. A small example:

create table test_ts(fid int, fts timestamp, fts_tz timestamp with time zone) in system;

insert into test_ts values (1, getdate(), getdate());
select * from test_ts;

-- The result
-- 1,'2013-09-06 14:02:10.571','2013-09-06 14:02:10.571+03:00'

The comments to this entry are closed.

My Photo

About Me

  • My name is Leonid Gvirtz, I'm freelance consultant in database-related areas. I work with various database-related technologies since 1995. I have a vast amount of experience in the design of databases and database-oriented applications, implementation, troubleshooting, performance & tuning, monitoring, and training.

January 2014

Sun Mon Tue Wed Thu Fri Sat
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31