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, GetDate(), 104) as ‘104 Conversion’, — 21.12.2010
convert(varchar, GetDate(), 105) as ‘105 Conversion’, — 21.12.2010
convert(varchar, GetDate(), 106) as ‘106 Conversion’, — 21 Dec 2010
convert(varchar, GetDate(), 107) as ‘107 Conversion’, — Dec 21, 2010
convert(varchar, GetDate(), 108) as ‘108 Conversion’, — 15:14:59
convert(varchar, GetDate(), 109) as ‘109 Conversion’, — Dec 21 2010  3:15:11:733PM
convert(varchar, GetDate(), 110) as ‘110 Conversion’, — 12.21.2010
convert(varchar, GetDate(), 111) as ‘111 Conversion’, — 2010/12/21
convert(varchar, GetDate(), 112) as ‘112 Conversion’, — 20101221
convert(varchar, GetDate(), 113) as ‘113 Conversion’, — 21 Dec 2010 15:16:09:470
convert(varchar, GetDate(), 114) as ‘114 Conversion’, — 15:16:19:843
convert(varchar, GetDate(), 120) as ‘120 Conversion’, — 2010.12.21 15:16:40
convert(varchar, GetDate(), 121) as ‘121 Conversion’, — 2010.12.21 15:16:49.750
convert(varchar, GetDate(), 126) as ‘126 Conversion’, — 2010.12.21T15:17:06.597
convert(varchar, GetDate(), 130) as ‘130 Conversion’, — backup_15 ???? 1432  3:18:11:347PM
convert(varchar, GetDate(), 131) as ‘131 Conversion’ — 15/01/1432  3:18:39:753PM

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.