Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

JDBC Query for TimeStamp loses precision

2 posts in General Discussion Last posting was on 2009-12-04 18:42:18.0Z
Saul Gonzalez Posted on 2009-12-04 18:31:14.0Z
Sender: 4183.4b17e648.1804289383@sybase.com
From: Saul Gonzalez
Newsgroups: ianywhere.public.general
Subject: JDBC Query for TimeStamp loses precision
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b195572.68bb.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 4 Dec 2009 10:31:14 -0800
X-Trace: forums-1-dub 1259951474 10.22.241.41 (4 Dec 2009 10:31:14 -0800)
X-Original-Trace: 4 Dec 2009 10:31:14 -0800, 10.22.241.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7811
Article PK: 6847

When I query for a timestamp, i get a time that seems to be
rounded to 1/300 of a second. I am using jconn3 and I
believe I downloaded the latest version as of Dec 3 2009.
Is there another jdbc driver that will give me the correct
time. The JDBC driver does insert the correct time to the
millisecond.


Glenn Paulley [Sybase iAnywhere] Posted on 2009-12-04 18:42:18.0Z
From: "Glenn Paulley [Sybase iAnywhere]" <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: JDBC Query for TimeStamp loses precision
References: <4b195572.68bb.1681692777@sybase.com>
In-Reply-To: <4b195572.68bb.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b19580a@forums-1-dub>
Date: 4 Dec 2009 10:42:18 -0800
X-Trace: forums-1-dub 1259952138 10.22.241.152 (4 Dec 2009 10:42:18 -0800)
X-Original-Trace: 4 Dec 2009 10:42:18 -0800, vip152.sybase.com
Lines: 42
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7812
Article PK: 6848

jConnect only supports 1/300th second precision with timestamp data
types. See

http://iablog.sybase.com/paulley/2009/03/differences-between-jconnect-and-the-ianywhere-jdbc-driver-part-un/

and

http://iablog.sybase.com/paulley/2009/10/differences-between-jconnect-and-the-ianywhere-jdbc-driver-part-deux/

You can use the iAnywhere JDBC driver, instead of jConnect, which
supports six-digit TIMESTAMP precision. Switching may require
application changes, depending on whether or not you are expecting
jConnect semantics from database requests.

Glenn

Saul Gonzalez wrote:
> When I query for a timestamp, i get a time that seems to be
> rounded to 1/300 of a second. I am using jconn3 and I
> believe I downloaded the latest version as of Dec 3 2009.
> Is there another jdbc driver that will give me the correct
> time. The JDBC driver does insert the correct time to the
> millisecond.

--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport