1 select mydate from tb 2 --结果 3 mydate 4 2008-4-9 5 2008-5-30 6 2008-3-7 7 2008-3-19 8 9 select convert(varchar(10),cast(mydate as datetime),120) as mydate from tb 10 11 --结果 12 mydate 13 2008-04-09 14 2008-05-30 15 2008-03-07 16 2008-03-19
1 select mydate from tb 2 --结果 3 mydate 4 2008-4-9 5 2008-5-30 6 2008-3-7 7 2008-3-19 8 9 select convert(varchar(10),cast(mydate as datetime),120) as mydate from tb 10 11 --结果 12 mydate 13 2008-04-09 14 2008-05-30 15 2008-03-07 16 2008-03-19
转载于:https://www.cnblogs.com/comrd/p/3245318.html