How to convert DateTime to VarChar

--
-- Create test case
--
DECLARE @myDateTime DATETIME
SET @myDateTime = '2008-05-03'

--
-- Convert string
--
SELECT LEFT(CONVERT(VARCHAR, @myDateTime, 120), 10)

CAST ( expression AS data_type [ (length ) ])

CONVERT ( data_type [ ( length ) ] , expression [ , style ] )

REPLACE(CONVERT(varchar(10), Date, 102), '.', '-')

mysql> select date(now());
+-------------+
| date(now()) |
+-------------+
| 2008-09-16  |
+-------------+
1 row in set (0.00 sec)

select replace(convert(varchar, getdate(), 111),'/','-');

SELECT CAST( CONVERT(VARCHAR, GETDATE(), 101) AS DATETIME) ;

convert( varchar(10), convert( date, @yourDate ) , 111 )