Link to home
Start Free TrialLog in
Avatar of Leopoled

asked on

Sybase conversion

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.
Avatar of Bud Durland
Bud Durland
Flag of United States of America image

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.
Avatar of wilcoxon
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial