• Hello,

    Try: Convert(Char(8), GetDate(), 112)

    Is that is the output that you need?

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group