Getting Only the Date Part of a Date/Time Stamp in SQL Server

Tech Talk Databases
1

To get the base back from the datetime in SQL:


    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