A way to extract from a DateTime value data without seconds

SELECT DATEADD(MINUTE, DATEDIFF(MINUTE, 0, yourcolumn), 0) FROM yourtable

This will be effective, if you don’t want a slow conversion between datatypes.