{"id":273,"date":"2007-03-16T16:05:58","date_gmt":"2007-03-16T15:05:58","guid":{"rendered":"http:\/\/www.galhano.com\/blog\/?p=273"},"modified":"2008-03-05T11:40:27","modified_gmt":"2008-03-05T10:40:27","slug":"covertendo-datas-em-texto","status":"publish","type":"post","link":"http:\/\/galhano.com\/blog\/?p=273","title":{"rendered":"Convertendo datas em texto"},"content":{"rendered":"

DateTime > varchar<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Select convert(varchar(30),getdate(),100)<\/font><\/td>\n><\/font><\/td>\nMar 16 2007 3:06PM<\/font><\/td>\n<\/tr>\n
Select convert(varchar(30),getdate(),101)<\/font><\/td>\n><\/font><\/td>\n03\/16\/2007<\/font><\/td>\n<\/tr>\n
Select convert(varchar(30),getdate(),102)<\/font><\/td>\n><\/font><\/td>\n2007.03.16<\/font><\/td>\n<\/tr>\n
Select convert(varchar(30),getdate(),103)<\/font><\/td>\n><\/font><\/td>\n16\/03\/2007<\/font><\/td>\n<\/tr>\n
Select convert(varchar(30),getdate(),104)<\/font><\/td>\n><\/font><\/td>\n16.03.2007<\/font><\/td>\n<\/tr>\n
Select convert(varchar(30),getdate(),105)<\/font><\/td>\n><\/font><\/td>\n16-03-2007<\/font><\/td>\n<\/tr>\n
Select convert(varchar(30),getdate(),106)<\/font><\/td>\n><\/font><\/td>\n16 Mar 2007<\/font><\/td>\n<\/tr>\n
Select convert(varchar(30),getdate(),107)<\/font><\/td>\n><\/font><\/td>\nMar 16, 2007<\/font><\/td>\n<\/tr>\n
Select convert(varchar(30),getdate(),108)<\/font><\/td>\n><\/font><\/td>\n15:06:04<\/font><\/td>\n<\/tr>\n
Select convert(varchar(30),getdate(),109)<\/font><\/td>\n><\/font><\/td>\nMar 16 2007 3:06:04:793PM<\/font><\/td>\n<\/tr>\n
Select convert(varchar(30),getdate(),110)<\/font><\/td>\n><\/font><\/td>\n03-16-2007<\/font><\/td>\n<\/tr>\n
Select convert(varchar(30),getdate(),111)<\/font><\/td>\n><\/font><\/td>\n2007\/03\/16<\/font><\/td>\n<\/tr>\n
Select convert(varchar(30),getdate(),112)<\/font><\/td>\n><\/font><\/td>\n20070316<\/font><\/td>\n<\/tr>\n
Select convert(varchar(30),getdate(),113)<\/font><\/td>\n><\/font><\/td>\n16 Mar 2007 15:06:04:793<\/font><\/td>\n<\/tr>\n
Select convert(varchar(30),getdate(),114)<\/font><\/td>\n><\/font><\/td>\n15:06:04:793<\/font><\/td>\n<\/tr>\n<\/table>\n

The list of styles that can be used are:<\/p>\n

Style ID\u00c2 Style Type
\n\u00c2
\n0 or 100\u00c2 mon dd yyyy hh:miAM (or PM)
\n101\u00c2 mm\/dd\/yy
\n102\u00c2 yy.mm.dd
\n103\u00c2 dd\/mm\/yy
\n104\u00c2 dd.mm.yy
\n105\u00c2 dd-mm-yy
\n106\u00c2 dd mon yy
\n107\u00c2 Mon dd, yy
\n108\u00c2 hh:mm:ss
\n9 or 109\u00c2 mon dd yyyy hh:mi:ss:mmmAM (or PM)
\n110\u00c2 mm-dd-yy
\n111\u00c2 yy\/mm\/dd
\n112\u00c2 yymmdd
\n13 or 113\u00c2 dd mon yyyy hh:mm:ss:mmm(24h)
\n114\u00c2 hh:mi:ss:mmm(24h)
\n20 or 120\u00c2 yyyy-mm-dd hh:mi:ss(24h)
\n21 or 121\u00c2 yyyy-mm-dd hh:mi:ss.mmm(24h)
\n126\u00c2 yyyy-mm-dd Thh:mm:ss.mmm(no spaces)
\n130\u00c2 dd mon yyyy hh:mi:ss:mmmAM
\n131\u00c2 dd\/mm\/yy hh:mi:ss:mmmAM
\n<\/p>\n","protected":false},"excerpt":{"rendered":"

DateTime > varchar Select convert(varchar(30),getdate(),100) > Mar 16 2007 3:06PM Select convert(varchar(30),getdate(),101) > 03\/16\/2007 Select convert(varchar(30),getdate(),102) > 2007.03.16 Select convert(varchar(30),getdate(),103) > 16\/03\/2007 Select convert(varchar(30),getdate(),104) > 16.03.2007 Select convert(varchar(30),getdate(),105) > 16-03-2007 Select convert(varchar(30),getdate(),106) > 16 Mar 2007 Select convert(varchar(30),getdate(),107) > Mar 16, 2007 Select convert(varchar(30),getdate(),108) > 15:06:04 Select convert(varchar(30),getdate(),109) > Mar 16 2007 3:06:04:793PM Select convert(varchar(30),getdate(),110) […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"close","ping_status":"close","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-273","post","type-post","status-publish","format-standard","hentry","category-sql-server","author-admin"],"_links":{"self":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/273","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=273"}],"version-history":[{"count":0,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/273\/revisions"}],"wp:attachment":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=273"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=273"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}