• use convert and apply a style to get only the date...

    select convert(varchar, getdate(), 101)

    there're any # of formats that you can apply - check BOL for the one that fits your need best!







    **ASCII stupid question, get a stupid ANSI !!!**