Converting Float into Date

• dreamslogic

  Ten Centuries

  Points: 1131

  More actions

  July 16, 2009 at 4:53 pm

  #134271

  Hi 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.

  tblfuelCost

  Fkey TotalAmountTransactionDateVehicleRego FuelPrice

  12057 20090706 AB155 1.20

  Thanks,

  Rahul

• Bruce W Cassidy

  SSChampion

  Points: 12668

  More actions

  July 16, 2009 at 5:00 pm

  #1025956

  [font="Verdana"]Try:

  convert(datetime, cast(TransactionDate as varchar(8)), 112)

  [/font]

• dreamslogic

  Ten Centuries

  Points: 1131

  More actions

  July 16, 2009 at 5:24 pm

  #1025960

  Thanks Very Much