SQLServerCentral / SQL Server 2005 / T-SQL (SS2K5) / Converting Float into Date / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 18:37:44 GMT20RE: Converting Float into Datehttp://www.sqlservercentral.com/Forums/Topic754551-338-1.aspxThanks Very Much :)Thu, 16 Jul 2009 17:24:46 GMTdreamslogicRE: Converting Float into Datehttp://www.sqlservercentral.com/Forums/Topic754551-338-1.aspx[font="Verdana"]Try:[code]convert(datetime, cast(TransactionDate as varchar(8)), 112)[/code][/font]Thu, 16 Jul 2009 17:00:11 GMTBruce W CassidyConverting Float into Datehttp://www.sqlservercentral.com/Forums/Topic754551-338-1.aspxHi Guys,I am trying to convert transaction Date to smalldatetime but no luck. Can any one please help me out with his.I need a query to convert transaction date float to smalltimedate. tblfuelCostFkey TotalAmount TransactionDate VehicleRego FuelPrice1 2057 20090706 AB155 1.20Thanks,RahulThu, 16 Jul 2009 16:53:19 GMTdreamslogic