<div>
Try this..<br />
<br />

<pre><code id="code-20-41917393-1">SELECT CONVERT(CHAR(10), DATETIME('2016-01-0 11:10:42.033189'), 118)</code></pre>
<br />
Hope it helps !!
</div>


Try this..



SELECT CONVERT(CHAR(10), DATETIME('2016-01-0 11:10:42.033189'), 118)


Hope it helps !!

<div>
a pleasure.<br />
<br />
It's probably also worth noting that I believe Pawan's answer relates to Sybase &quot;SQL Anywhere&quot;, see:<br />
<a href="http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32300.1570/html/sqlug/BABDBAHF.htm" rel="ugc">http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32300.1570/html/sqlug/BABDBAHF.htm</a>
</div>


a pleasure.

It's probably also worth noting that I believe Pawan's answer relates to Sybase "SQL Anywhere", see:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32300.1570/html/sqlug/BABDBAHF.htm [http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32300.1570/html/sqlug/BABDBAHF.htm]

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
I have a SyBase database and when I select the field I get <br />
<br />
<b>9/19/2016 4:05:00 PM</b><br />
<br />
I want to return only the the time portion in HH:MM 24 hour format....desired return is: <b>16:05</b><br />
<br />
Another example:<br />
<br />
<b>9/19/2016 12:53:00 PM</b> should return <b>12:53</b><br />
<br />
<br />
I cant seem to find the right combination of date/time format to get me this....help?
</div>
</div>


Hello Experts,

I have a SyBase database and when I select the field I get 

9/19/2016 4:05:00 PM

I want to return only the the time portion in HH:MM 24 hour format....desired return is: 16:05

Another example:

9/19/2016 12:53:00 PM should return 12:53


I cant seem to find the right combination of date/time format to get me this....help?

SyBase Query Syntax Date Time 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.

Sybase Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.