Use TRUNC function to get weekday

  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