<div>
That simply truncates it, right?
</div>


<div>
It is funny how simple some solutions are...
</div>


It is funny how simple some solutions are...

<div>
Wish all solutions were like that ;-)
</div>


<div>
<div class="content wysiwyg-content">
I know I asked this before, but I can't find the answer.<br />
<br />
I have an SQL table that has a date field. &nbsp;A piece of the SQL stored procedure that returns the date is:<br />
CONVERT(varchar,duration,1<wbr />4) AS duration<br />
<br />
It comes back as: hh:mm:ss:mss<br />
<br />
I need it: hh:mm:ss:ms<br />
<br />
I would swear it worked at one time...<br />
<br />
I would prefer to fix it on the SQL side as this store procedure is used in many places.
</div>
</div>


I know I asked this before, but I can't find the answer.

I have an SQL table that has a date field.  A piece of the SQL stored procedure that returns the date is:
CONVERT(varchar,duration,14) AS duration

It comes back as: hh:mm:ss:mss

I need it: hh:mm:ss:ms

I would swear it worked at one time...

I would prefer to fix it on the SQL side as this store procedure is used in many places.

Need 2 digit Millisecond

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.