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