FIGURE 4: Three Select Statements and Results

select convert(char(20), getdate( ), 1 ) as style1
select convert(char(20), getdate( ), 4 ) as style4
select convert(char(20), getdate( ), 105 ) as style105

Results:

style1           
----------------------
06/08/00        

style4           
----------------------
07/8.06.00        

style105         
----------------------
08-06-2000