{"id":357,"date":"2023-09-16T10:44:52","date_gmt":"2023-09-16T02:44:52","guid":{"rendered":""},"modified":"2023-09-18T11:50:02","modified_gmt":"2023-09-18T03:50:02","slug":"sql%e5%b0%86datetime%e8%bd%ac%e5%8c%96%e4%b8%ba%e5%ad%97%e7%ac%a6%e4%b8%b2%e5%b9%b6%e6%88%aa%e5%8f%96%e5%ad%97%e7%ac%a6%e4%b8%b2","status":"publish","type":"post","link":"https:\/\/mushiming.com\/357.html","title":{"rendered":"SQL\u5c06datetime\u8f6c\u5316\u4e3a\u5b57\u7b26\u4e32\u5e76\u622a\u53d6\u5b57\u7b26\u4e32"},"content":{"rendered":"

select sr_child as '\u5b69\u5b50\u59d3\u540d', sr_parents as '\u5bb6\u957f\u59d3\u540d' ,ss_updatetime as '\u5206\u914d\u65f6\u95f4', left(ss_updatetime,CHARINDEX(' ',ss_updatetime)-1),SUBSTRING(CONVERT(CHAR(19), ss_updatetime, 120)<\/span>,1,10)as '\u8f6c\u6362\u683c\u5f0f\u5e76\u622a\u53d6\u540e\u7684\u65f6\u95f4'<\/span>from dbo.tb_sell_resources,dbo.tb_sell_selldetails where sr_id = ss_rsid and ss_qdstate <> 1 order by ss_updatetime<\/p>\n

 <\/p>\n

\"SQL\u5c06datetime\u8f6c\u5316\u4e3a\u5b57\u7b26\u4e32\u5e76\u622a\u53d6\u5b57\u7b26\u4e32<\/p>\n

 <\/p>\n

sql \u4e2d\u5b57\u7b26\u4e32\u622a\u53d6\u51fd\u6570\uff1a SUBSTRING(name<\/span>,start,end)<\/span><\/p>\n

                         name\uff1a \u5b57\u7b26\u4e32\u683c\u5f0f\u7684 \u5b57\u6bb5\u540d<\/span><\/p>\n

                           start\uff1a \u89c4\u5b9a\u5f00\u59cb\u4f4d\u7f6e\uff08\u8d77\u59cb\u503c\u662f 1\uff09<\/span><\/p>\n

                            end\uff1a\u622a\u53d6\u5b57\u7b26\u4e32\u7ed3\u675f\u7684\u4f4d\u7f6e<\/span><\/p>\n

<\/span> <\/p>\n

sql \u4e2dDatetime\u683c\u5f0f\u8f6c\u6362\u4e3a\u5b57\u7b26\u4e32\u683c\u5f0f\uff1a  2000-01-01 01:01:01\uff08Datetime\uff09    CONVERT(CHAR(19), CURRENT_TIMESTAMP, 120)<\/span><\/span><\/p>\n

                   CURRENT_TIMESTAMP\uff1a  \u5f53\u524d\u65f6\u95f4\uff08\u6b64\u5904\u53ef\u4ee5\u5199Datetime\u683c\u5f0f\u7684\u5b57\u6bb5\u540d\uff0c\u4f8b\u5982ss_updatetime\uff09<\/span><\/p>\n

                   \u5176\u4f59\u7684\u53c2\u6570\uff08CHAR(19), 120\u7b49\uff09\u4e0d\u7528\u4fee\u6539<\/span><\/p>\n

                   \u4f7f\u7528\u4e4b\u540e  2000-01-01 01:01:01\uff08Datetime\uff09<\/span>\u53d8\u4e3a  2000-01-01 01:01:01\uff08\u5b57\u7b26\u4e32\u683c\u5f0f\uff09<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"selectsr_childas'\u5b69\u5b50\u59d3\u540d',sr_parentsas'\u5bb6\u957f\u59d3\u540d',ss_updatetimeas'\u5206\u914d\u65f6\u95f4',left(ss_updatetime,CHARINDEX('',ss_update...","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[82],"tags":[],"_links":{"self":[{"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/posts\/357"}],"collection":[{"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/comments?post=357"}],"version-history":[{"count":0,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/posts\/357\/revisions"}],"wp:attachment":[{"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/media?parent=357"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/categories?post=357"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/tags?post=357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}