<div>
Assuming convert is the same between ASE and SQL Anywhere (100 is the same at least):<br />
<br />
convert(varchar(20),t.time<wbr />ord,1)+' '+convert(varchar(20),t.ti<wbr />meord,14)<br />
gives you 03/07/14 17:06:19 (24-hour clock)<br />
<br />
convert(varchar(20),t.time<wbr />ord,1)+' '+convert(varchar(20),t.ti<wbr />meord,36)<br />
gives you 03/07/14 05:06:19.000000PM (eg includes microseconds)<br />
<br />
Oddly, I can't find any format that gives you exactly what you want.
</div>


<div>
It looks like SQL Anywhere is a little different. &nbsp;Checking the ref docs, 36 isn't listed and 14 includes the microseconds. &nbsp;I'd suggest giving both my suggestions in my previous post a try and see if they work (and if they include the microseconds).<br />
<br />
If it is important to remove microseconds, that can be accomplished by calling some other functions.
</div>


<div>
select convert(varchar(20),timeor<wbr />d,1)+' '+convert(varchar(20),time<wbr />ord,36) from dba.posdetail<br />
<br />
Returns<br />
<br />
03/07/14 2014-03-07 21:37:10.<br />
<br />
<br />
select convert(varchar(20),timeor<wbr />d,1)+' '+convert(varchar(20),time<wbr />ord,14) from dba.posdetail<br />
<br />
Returns<br />
<br />
03/07/14 21:37:10:079<br />
<br />
<br />
<br />
Looks like both are 24 hour mode. I need 12 hour AM/PM with hour, minute, and seconds.
</div>


<div>
Less code for the same result.
</div>


<div>
<div class="content wysiwyg-content">
Sybase SQL Anywhere v10<br />
<br />
I am using CONVERT(VARCHAR(20),t1.tim<wbr />eord, 100) and I get &quot;Mar 07 2014 05:06PM&quot;<br />
<br />
I want shortened date and I need the seconds as well. <b>03/07/14 05:06:19PM</b><br />
<br />
Thanks in advance.
</div>
</div>


Sybase SQL Anywhere v10

I am using CONVERT(VARCHAR(20),t1.timeord, 100) and I get "Mar 07 2014 05:06PM"

I want shortened date and I need the seconds as well. 03/07/14 05:06:19PM

Thanks in advance.

SyBase SQL DataTime Format

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.