how to view date dimenstion

plese help
I want to view date dimentions like DD/MM/YY, doen't want to include time.
Thank youSELECT Convert(varchar(10), GetDate(), 105) as date

For more option explore convert() function...sql