Home Forums Programming General SELECT short date RE: SELECT short date

  • June 18, 2003 at 12:17 pm

    #461971

    USE:

    

    CONVERT(DATETIME, DATEDIFF(DAY, 0, GETDATE()))

    to strip the time portion of the date.

    Edited by - jpipes on 06/18/2003 12:20:51 PM