Microsoft SQL Server Articles

Links, articles, scripts, tips, and other technical sources for managing SQL Server. DBALinks is dedicated to SQL Server and database administration.

ABOUT SQL SERVER

 

 

Articles | Categories | Search | Syndication

Articles from Date Formatting
How to Get Only the Date Part of a Date/Time Stamp in SQL Server without Time Part
How to Get Only the Date Part of a Date/Time Stamp in SQL Server without Time Part
170 Views
0 Comments

T-SQL, Date Formatting

Is this the best way to get only the date part of a date/time stamp in SQL Server without time part?

Select CAST(FLOOR( CAST( GETDATE() AS FLOAT ) )AS DATETIME)

Read More..