select year(translate(a.complaintdate,'/','-')) b , '年' as 查询方式from TIANMA_BI.DWD_ZXYCLZL_KPI01_0KM_COMPLAINT_DETAIL aunion allselect month(translate(a.complaintdate,'/','-')) b, '月' as 查询方式from TIANMA_BI.DWD_ZXYCLZL_KPI01_0KM_COMPLAINT_DETAIL aunion allselect quarter(translate(a.complaintdate,'/','-')) b, '季度' as 查询方式from TIANMA_BI.DWD_ZXYCLZL_KPI01_0KM_COMPLAINT_DETAIL aunion allselect weekofyear(translate(a.complaintdate,'/','-')) b, '周' as 查询方式from TIANMA_BI.DWD_ZXYCLZL_KPI01_0KM_COMPLAINT_DETAIL aunion allselect dayofweek(translate(a.complaintdate,'/','-')) b, '天' as 查询方式from TIANMA_BI.DWD_ZXYCLZL_KPI01_0KM_COMPLAINT_DETAIL a