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®

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
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