摘要： convert(varchar(10),字段名,转换格式)比如：1.select user_id,convert(varchar(10),dayts,11) as dates from tb_user (sybase下及sql server下语句)2.select to_char(sysdate,'yy/mm/dd') as d from dual (oracle下语句）转换格式：0或100 month dd yyyy hh:miampm1 mm/dd/yy2 yy.mm.dd3 dd/mm/yy4 dd.mm.yy5 dd-mm-yy6 dd month yy7 month 阅读全文