<div>
YIKES that was fast. &nbsp;That solved the problem but unfortunately the Telerik control I am using still doesn't convert it properly. &nbsp;Awarding points.
</div>


YIKES that was fast.  That solved the problem but unfortunately the Telerik control I am using still doesn't convert it properly.  Awarding points.

<div>
<div class="content wysiwyg-content">
I am currently doing the following when in my SQL stored proc to convert a DateTime to a Float.<br />
<br />
CAST([my_Date] AS FLOAT) + 2 as ConDate<br />
<br />
This works fine except when I have a date such as '2010-11-11 00:00:00.000'. &nbsp;Then the result is returned with no decimal places and when I convert that to a date in a .NET application it is translated as 2010-11-11 12:00:00.000 which isn't correct.<br />
<br />
Anyone know if I can force the extra three decimal places?
</div>
</div>


I am currently doing the following when in my SQL stored proc to convert a DateTime to a Float.

CAST([my_Date] AS FLOAT) + 2 as ConDate

This works fine except when I have a date such as '2010-11-11 00:00:00.000'.  Then the result is returned with no decimal places and when I convert that to a date in a .NET application it is translated as 2010-11-11 12:00:00.000 which isn't correct.

Anyone know if I can force the extra three decimal places?

SQL Server DateTime to Float conversion

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.

Microsoft SQL Server

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications