{"id":8584,"date":"2010-04-11T23:06:59","date_gmt":"2010-04-11T15:06:59","guid":{"rendered":"http:\/\/bohu.net\/blog\/?p=8584"},"modified":"2010-04-11T23:06:59","modified_gmt":"2010-04-11T15:06:59","slug":"sql%e6%97%b6%e9%97%b4%e8%bd%acvarchar%e5%ad%97%e7%ac%a6%e4%b8%b2","status":"publish","type":"post","link":"https:\/\/www.bohu.net\/blog\/8584\/","title":{"rendered":"Sql\u65f6\u95f4\u8f6cvarchar\u5b57\u7b26\u4e32"},"content":{"rendered":"

 <\/p>\n

\n
\n

CONVERT(data_type,expression_r_r[,style])<\/p>\n

\u8bed\u53e5\u53ca\u67e5\u8be2\u7ed3\u679c\uff1a<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 0): 05 16 2006 10:57AM<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 1): 05\/16\/06<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 2): 06.05.16<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 3): 16\/05\/06<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 4): 16.05.06<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 5): 16-05-06<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 6): 16 05 06<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 7): 05 16, 06<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 8): 10:57:46<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 9): 05 16 2006 10:57:46:827AM<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 10): 05-16-06<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 11): 06\/05\/16<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 12): 060516<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 13): 16 05 2006 10:57:46:937<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 14): 10:57:46:967<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 20): 2006-05-16 10:57:47<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 21): 2006-05-16 10:57:47.157<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 22): 05\/16\/06 10:57:47 AM<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 23): 2006-05-16<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 24): 10:57:47<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 25): 2006-05-16 10:57:47.250<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 100): 05 16 2006 10:57AM<\/p>\n

SELECT CONVERT(varchar(100), GETDATE_r(), 101): 05\/16\/2006<\/p>\n

SELECT CONVE<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

  CONVERT(data_type,expression_r_r[,style]) \u8bed\u53e5\u53ca\u67e5\u8be2\u7ed3 … \u7ee7\u7eed\u9605\u8bfb\u201cSql\u65f6\u95f4\u8f6cvarchar\u5b57\u7b26\u4e32\u201d<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,9,23],"tags":[336,358,359],"class_list":["post-8584","post","type-post","status-publish","format-standard","hentry","category-sql","category-sql-server-sql","category-23","tag-select","tag-sql-2","tag-sql-server"],"_links":{"self":[{"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/posts\/8584","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/comments?post=8584"}],"version-history":[{"count":0,"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/posts\/8584\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/media?parent=8584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/categories?post=8584"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/tags?post=8584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}