3> SELECT
4> 'returned as date'=GETDATE(),
5> 'returned as string'=CONVERT(varchar(20), GETDATE())
6> GO
returned as date returned as string
----------------------- --------------------
2008-08-17 13:20:33.890 Aug 17 2008 1:20PM
(1 rows affected)
1>
2>