SELECT*FROM表WHERETRUNC(start_date_time )=TRUNC(discharge_date_time);说明:TRUNC 为日期的截尾SELECT '现在' AS truncType , SYSDATE FROM DUALUNION ALL SELECT '年' AS truncType , TRUNC( SYSDATE, 'YYYY' ) FROM DUALUNION ALLSELECT '季度' AS truncType, TRUNC( SYSDATE, 'Q' ) FROM DUALUNION ALLSELECT '月' AS truncType, TRUNC( SYS...
|