Post reply

Converting Float into Date

  • 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

  • July 16, 2009 at 5:00 pm

    #1025956

    [font="Verdana"]Try:

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

    [/font]

  • July 16, 2009 at 5:24 pm

    #1025960

    Thanks Very Much 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply