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.
Sybase Database
Last Comment
wilcoxon
8/22/2022 - Mon
Bud Durland
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