Shulou(Shulou.com)05/31 Report--

This article introduces the knowledge of "what is the sentence of removing time from datetime field in sql server". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

SelectCONVERT (varchar,getdate (), 2004-09-1211) 2004-09-1211 selectCONVERT 06 selectreplace (replace (replace (CONVERT (varchar,getdate ()),\'-',\'),\',\'), 20040912110608 selectCONVERT (varchar (12), getdate (), 111l) 2004-09-12 selectCONVERT (varchar (12), getdate (), 20040912 selectCONVERT (varchar (12), getdate (), 102) September 12, 2004 selectCONVERT (varchar (12), getdate () SelectCONVERT (varchar (12), getdate (), 10312) 12.09.2004 selectCONVERT (varchar (12), getdate (), 12092004 selectCONVERT (varchar (12), getdate (), 107) 0912 selectCONVERT (varchar (12), getdate (), 11:06:08 selectCONVERT (varchar (12), getdate (), 109) 091220041 selectCONVERT (varchar (12), getdate () ) 09-12-2004 selectCONVERT (varchar (12), getdate (), 11313) 120920041 selectCONVERT (varchar (12), getdate (), 11411411) 06selectCONVERT 08.177 selectCONVERT (varchar (10), getdate (), 120) "what is the statement for removing the time of datetime field in sql server"? Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.