Home Forums SQL Server 2005 T-SQL (SS2K5) Convert varchar back into datetime?? RE: Convert varchar back into datetime??

  • April 24, 2013 at 1:11 pm

    #1609696

    david.ostrander (4/24/2013)

    Lynn -

    Thank you for the tip.

    I used dateadd(dd, datediff(dd, 0, d.DocDate), 0) but how do I get rid of the

    "00:00:00:00"?

    Thanks,

    David

    If you want the datatype to be datetime, you don't.

    If you are exporting this data to Excel, let Excel deal with the formatting of the dates.