Código SQL [-]select cast(TuCAMPOTimeStamp as date) from TUTABLA
select cast(TuCAMPOTimeStamp as date) from TUTABLA