<--- --------------------------------------------------------------------------------------- ----
	
	Blog Entry:
	Getting Only the Date Part of a Date/Time Stamp in SQL Server
	
	Author:
	Ben Nadel / Kinky Solutions
	
	Link:
	http://www.bennadel.com/index.cfm?dax=blog:122.view
	
	Date Posted:
	Jul 7, 2006 at 6:05 PM
	
---- --------------------------------------------------------------------------------------- --->


CAST(
	(
		STR( YEAR( GETDATE() ) ) + '/' +
		STR( MONTH( GETDATE() ) ) + '/' +
		STR( DAY( GETDATE() ) )
	)
	AS DATETIME 
)