Conversion Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Conversion Functions
  4. To_char(sysdate,DAY dy Dy)
SQL>
SQL> select to_char(sysdate,'DAY dy Dy') as day
  2  from dual;
DAY
-----------------
THURSDAY  thu Thu
SQL>