Removes the time part from a date. The example below shows a date column generated from the current
server date and time (GETDATE) and the TRUNC'd VALUE.
SELECT GETDATE() as CurrentDateWithTimeStamp, TRUNC(GETDATE()) AS TruncDateOnly
/* Returns the table
6/3/2016 9:42 AM 6/3/2016
Please sign in to leave a comment.