Display date

Hi all

column "datetime" in table i need to create view and display only date

any formate do this

thanks&regards

Code Snippet

SELECT CONVERT(varchar(10), datecolumn, 101)

See CONVERT in BOL for more options than 101.

|||Look up CAST and CONVERT in books online.