• There are several ways that you can accomplish this. Probably the most straightforward is the following.

    SELECT CAST(CAST(GETDATE() AS DATE) AS SMALLDATETIME)

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA