Oracle-获取星期几

这样尝试

SELECt CASE        WHEN trim(TO_CHAr(SYSDATE, 'Day')) = 'Tuesday' THEN 'Its Tuesday'       ELSE 'Its Not Tuesday'         END AS case_result,       TO_CHAr(SYSDATE, 'Day') AS DAYFROM  DUAL;

或者按照ajmalmhd04的建议，您可以尝试点赞

FmDay

SELECt CASE        WHEN TO_CHAr(SYSDATE, 'FmDay') = 'Tuesday' THEN 'Its Tuesday'       ELSE 'Its Not Tuesday'         END AS case_result,       TO_CHAr(SYSDATE, 'Day') AS DAYFROM  DUAL;