<--- --------------------------------------------------------------------------------------- ----
	
	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
	
---- --------------------------------------------------------------------------------------- --->


SELECT
	-- Get the full date/time stamp as a base.
	(
		GETDATE()
	) AS date_time_part,
	 
	-- Trying casting to a string then back to a date.
	(
		CAST(
			(
				STR( YEAR( GETDATE() ) ) + '/' +
				STR( MONTH( GETDATE() ) ) + '/' +
				STR( DAY( GETDATE() ) )
			)
			AS DATETIME 
		)
	) AS date_only_part,
	 
	-- Try casting to float, rounding, and back to date.
	(
		CAST(
			FLOOR( CAST( GETDATE() AS FLOAT ) )
			AS DATETIME
		)
	) AS date_only_part2,
	 
	-- Try casting just to float to see what it looks like.
	(
		CAST( GETDATE() AS FLOAT )
	) AS float_value,
	 
	-- Try flooring to see the intermediary step.
	(
		FLOOR( CAST( GETDATE() AS FLOAT ) )
	) AS int_value