• 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."