On Wed, 2003-01-22 at 18:09, David H. Lynch Jr. wrote: > I have always had a particular affection for Dates as Julian day > numbers the number of days since xxxx. > > They are really easy to manipulate, compare, Virtually all the > nasty aspects of dates become a function of the routines for printing > them or inputting them, Ignoring issues of the differing calendars used > prior to the late 1700's you can represent most of recorded history in a > 3 byte integer. > > I have never understood why most databases tended to store dates > in any other format.
Internally Sybase stores dates as two 32bit ints. The first is the number of days since jan 1 1900. The second is the number of 300th of a second since midnight. Michael -- Michael Peppler Data Migrations, Inc. [EMAIL PROTECTED] http://www.mbay.net/~mpeppler Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or long term contract positions - http://www.mbay.net/~mpeppler/resume.html
