both work for me:
select cast (getdate() as smalldatetime)
select convert(smalldatetime,getdate())
select @@version
results:
-----------------------
2009-07-17 09:16:00
(1 row(s) affected)
-----------------------
2009-07-17 09:16:00
(1 row(s) affected)
------------------------------------------------
Microsoft SQL Server 2005 - 9.00.4207.00 (X64)
(1 row(s) affected)
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."