Sybase Date Format

[Ferrian]

Hello all.

I've been thrown in to the deep end and asked to edit some reports that talk to a sybase database, a system that I've never used before.

I am having serious problems trying to work out how the date cell relates to the actual date, in the columns I have the following:

a report from 06/09/2005 is '131401990'
a report from 03/09/2005 is '131401987'
a report from 30/08/2005 is '131401758'
etc

If anyone can help me work out a) how these numbers relate to the date and b) how to convert them in my SQL (this part isn't so important) I'd be very grateful.

Thanks

Ben

 

[DotNetGnat]

you should find answer here:

http://manuals.sybase.com/onlineboo...sqlug/@Generic__BookTextView/25439;pt=25357/*

just set the correct Date format and you are good to go...

-DNG