Home > Article > Backend Development > Database date format conversion_PHP tutorial
Database date format conversion_PHP tutorial
- WBOYOriginal
- 2016-07-21 16:04:10864browse
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