Tom M

Recent Blog Comments By Tom M

• Getting Only the Date Part of a Date/Time Stamp in SQL Server

  Posted on Sep 8, 2011 at 5:08 AM

  @Dewald, the need for converting to a floored float and then back to datetime is that for previous versions of SQL Server the DATE and TIME data types do not exist.... read more »

• Getting Only the Date Part of a Date/Time Stamp in SQL Server

  Posted on Jul 28, 2010 at 8:06 AM

  @Ben, Your solution looks more elegant than what I've been using in the past, but wouldn't the following be just as efficient or is floor() better than cast to varchar? cast(cast(getdate() as varchar(11)) as datetime)... read more »