Home Forums SQL Server 2008 SQL Server 2008 - General Help with doing “Cast the decimal as string, parse into the format specified, and then cast back into datetime”? RE: Help with doing “Cast the decimal as string, parse into the format specified, and then cast back into datetime”?

  • November 20, 2012 at 8:23 am

    #1560833

    I have broken down the reqs into 3 parts

    1)Cast decimal as string ( which I did)

    select convert(varchar,convert(decimal(8,0),[I353_DATE_TRANSACTION]))

    from [stgFACTS].[dbo].[I353_SalesOrder]

    2), parse into the format specified(which is MM/DD/YYYY....I don’t know how to do that..f)

    3)and then cast back into datetime” (I don’t know how to do that)

    Thx

    SM