Sybase conversion

Leopoled
Leopoled used Ask the Experts™
on
How can I convert bigint in Sybase to a normal representation of a day and time. For example I have in Sybase value of the EndTime bigint -->      1,441,126,804
I am doing a report so need to show it in the date format.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Bud DurlandDirector of IT

Commented:
I'm not sure what you are looking for is directly supported, but I've never tried.  I usually store my dates as dates.  

The CAST and CONVERT functions will be your friend here.
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38151.1510/html/iqrefbb/X315936.htm
Commented:
You might be better reading the date out into whatever is generating your report and converting it there.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial