Select Code to Download

  select convert( char(8), gedate(), 1 )

  select convert( char(10), getdate(), 101 )