Thanx a lot. I combined the Convert with the LEFT function to get rif of the seconds.

LEFT (CONVERT (varchar(20); {datetime}; 8); 5)