Database date format conversion_PHP tutorial

It is enough to specify the date format code in convert, such as:

select convert(char(20),getdate(),101)
select emp_id,convert(char(20),hire_dt, 101) from employee


---------------------------------------- ----------------

Date Format Code
-------------------- -- ----------
04/05/2000 101

-------------------- ------ -----
2000.04.05 102

-------------------- -----------
05/04/2000 103

-------------------------- -----------
05.04. 2000 104

--------------------- -----------
05-04-2000 105

--------------------- ----------
05 Apr 2000 106

-- ------------------ ----------
Apr 05, 2000 107

------- ------------- -----------
11:33:24 108

---------- ---------- ----------
Apr 5 2000 11:33:24 109

------------ -------- ----------
04-05-2000 110

---------------- ---- -----------
2000/04/05 111

-------------------------- -----------
20000405 112

http://www.bkjia.com/PHPjc/316015.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/316015.htmlTechArticleIt is enough to specify the date format code in convert, such as: select convert(char(20),getdate (),101) select emp_id,convert(char(20),hire_dt,101) from employee -----------------------...