select TRIM(',' from name) as name from t; --获取当前系统日期(day) select TO_char(SYSDATE,'YY-MM-DD') from dual;