The expression is mostly self-explanatory and does not need to make date-to-string-substring-to-date conversions to achieve the same effect.
Internally - datetime is just 8-byte FLOAT number as stored by SQL Server with right section of the decimal point representing number of dates since 01-Jan-1900 (hence 0 is 01 Jan 1900 12:00AM) and fractional section is the time (0.5 is 12:00 PM, 0.25 is 4:00 AM, 0.75 is 4:00PM etc).
DECLARE @DateOnly DATETIME SET @DateOnly = CAST(FLOOR(CAST(GetDate() AS FLOAT)) AS DATETIME)
2013-03-18
2,093 reads
2011-11-28
2,730 reads
2011-09-27
2,758 reads
Accuracy and precision go hand-in-hand. This script helps trim date values to whatever size is stored in a table's column.
2010-01-20 (first published: 2009-12-21)
1,440 reads
Function do return common datatime formats of a date.
select dbo.[KDT_FN_FORMATDATETIME]('LASTDAY DDDD',getdate())
2016-04-26 (first published: 2016-03-29)
1,610 reads
