Path: utzoo!utgpu!news-server.csri.toronto.edu!rutgers!cs.utexas.edu!sun-barr!apple!netcom!amdcad!sun!newstop!jethro!backnine.Corp.Sun.COM!gerardt
From: gerardt@backnine.Corp.Sun.COM (Gerard Tynen)
Newsgroups: comp.databases
Subject: Sybase timestamps -- are they really?
Message-ID: <3838@jethro.Corp.Sun.COM>
Date: 13 Apr 91 00:14:40 GMT
Sender: news@jethro.Corp.Sun.COM
Reply-To: gerardt@backnine.Corp.Sun.COM (Gerard Tynen)
Distribution: usa
Organization: Sun Microsystems, Inc.  Mt. View, Ca.
Lines: 15


Does anyone know if the timestamp datatype in Sybase denotes
an actual time and date?  

I have tried converting timestamps as follows (in isql):

	select convert(datetime, timestamp) from [table with timestamp]


and got a date in the year 2067 AD.

This may be another example of the Sybase engineers taking a 
martini break just before making a major design decision, but
one ought to expect the timestamp to denote exactly the time a
row was updated. Si? No?