Post reply

Float to Date

  • August 9, 2007 at 10:46 am

    #121025

    I have a database from a vendor that has the date/time stored as a float.

    Example: 20070809100330.0

    I think it is YYYYMMDDHHMMSS

    I would like to convert that into a date time, but I am totally stumped. I tried casting/converting it to a varchar and then doing string functions on it, but I can't get the desired results.

  • August 9, 2007 at 11:32 am

    #725815 

    declare @f float
set @f =20070809100330.0
    select convert(datetime,stuff(stuff(stuff(convert(bigint,@f),9,0,' '),12,0,':'),15,0,':'))

  • August 9, 2007 at 11:42 am

    #725818

    Michael, I would buy you a beer if I could for that syntax. I was nowhere near that. Worked like a charm, Thanks!

  • August 9, 2007 at 11:48 am

    #725821

    There's always paypal .

  • August 9, 2007 at 2:03 pm

    #725847

    Heh... forget PayPal... UPS will ship a keg

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • August 9, 2007 at 2:27 pm

    #725855

    Paypal does that too .

Viewing 6 posts - 1 through 6 (of 6 total)

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