Posted onFebruary 7, 2011 by Josephine get only date part of datetime stamp CAST( FLOOR( CAST( GETDATE() AS FLOAT ) ) AS DATETIME )
