<div>
I'm not sure what you are looking for is directly supported, but I've never tried. &nbsp;I usually store my dates as dates. &nbsp;<br />
<br />
The CAST and CONVERT functions will be your friend here.<br />
<a href="http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38151.1510/html/iqrefbb/X315936.htm" rel="ugc">http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38151.1510/html/iqrefbb/X315936.htm</a>
</div>


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 [http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38151.1510/html/iqrefbb/X315936.htm]

<div>
<div class="content wysiwyg-content">
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 --&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1,441,126,804<br />
I am doing a report so need to show it in the date format.
</div>
</div>


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 conversion

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.