Home > Article > Backend Development > English date format database date format conversion
English date format database date format conversion
- WBOYOriginal
- 2016-07-29 08:33:522736browse
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 --------------- -----------
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
The above introduces the English date format and database date format conversion, including the content of English date format. I hope it will be helpful to friends who are interested in PHP tutorials.