只要在convert中指定日期格式的代号就够了,如:selectconvert(char(20),getdate(),101)selectemp_id,convert(char(20),hire_dt,101)fromemployee-----------------------------------------------------日期格式代号-------------------------------04/05/2000101-------------------------------2000.04.05102-------------------------------05/04/2000103-------------------------------05.04.2000104-------------------------...