Use TRUNC function to get weekday

From: <>
Date: Tue, 21 Apr 2009 14:26:52 -0700 (PDT)
Message-ID: <>


  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

Original text of this message