Use TRUNC function to get weekday
Date: Tue, 21 Apr 2009 14:26:52 -0700 (PDT)
Is it possible to use TRUNC function to get the weekday (e.g. Monday, Tuesday ...)? I know I can use TO_CHAR to get it:
select TO_CHAR(trunc(sysdate), 'DAY') weekday, TO_CHAR(sysdate, 'D') day_of_week from dual;
Thanks in advance.
Nick Li Received on Tue Apr 21 2009 - 16:26:52 CDT