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

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 Reviews :: :: T-SQL, Date Formatting 		 

How 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)
Rating
Reviews
Currently, there are no reviews. Be the first to post one!
Click here to post a review
 
Copyright 2007 by www.dballinks.com   Terms Of Use   Privacy Statement    
Home   SQL Server Blogs   DotNetNuke   SQL Server   SQL Server Articles   Contact Us