Home Forums Programming General SELECT short date RE: SELECT short date
jpipes
SSChampion
Points: 12230
More actions
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