Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Conversion Functions

 

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>