Hi, Great to see all the ways to manipulate dates in SQL.
Here is another way of doing it rather quickly.
SELECT CAST(CAST(GETDATE() AS CHAR(11)) AS DATETIME)
Cool stuff,
Hanri
Whenever I get sad, I stop being sad and be awesome instead… true story!