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

  • April 24, 2013 at 12:41 pm

    #1609685

    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