select convert(char(20),getdate(),101)
select emp_id,convert(char(20),hire_dt,101) from employee
-----------------------------------------------------
日期格式;;代号
-------------------- -----------
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
标签：
