Date format conversion for database _php tutorial

As long as you specify a date format in convert, the code is sufficient, such as:

Select CONVERT (char), GETDATE (), 101)
Select Emp_id,convert (char), hire_dt,101) from employee


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

Date format Code
-------------------- -----------
04/05/2000 on 101

-------------------- -----------
2000.04.05 on 102

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

-------------------- -----------
05.04.2000 104

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

-------------------- -----------
APR 2000 106

-------------------- -----------
APR 05, 2000 107

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

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

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

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

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

http://www.bkjia.com/PHPjc/316015.html www.bkjia.com true http://www.bkjia.com/PHPjc/316015.html techarticle as long as you specify the name of the date format in convert, such as: select CONVERT (char (), GETDATE (), 101) Select Emp_id,convert (char (), hire_dt,101) From Employee-----------------------...

