sql server date conversion methods

–date conversion methods:  also 127 in ics file select convert(varchar, GetDate(), 100) as ‘100 Conversion’, — Dec 21 2010  3:13PM convert(varchar, GetDate(), 101) as ‘101 Conversion’, — 12/21/2010 convert(varchar, GetDate(), 102) as ‘102 Conversion’, — 2010.12.21 convert(varchar, GetDate(), 103) as ‘103 Conversion’, — 21/12/2010 convert(varchar,…