How to get the week day name from a date?

by 
SQL> SELECT TO_CHAR(date '1982-03-09', 'DAY') day FROM dual;

DAY
---------
TUESDAY

SQL> SELECT TO_CHAR(date '1982-03-09', 'DY') day FROM dual;

DAY
---
TUE

SQL> SELECT TO_CHAR(date '1982-03-09', 'Dy') day FROM dual;

DAY
---
Tue

(Note that the queries use ANSI date literals, which follow the ISO-8601 date standard and avoid date format ambiguity.)

More Related Contents:

  1. How are dates stored in Oracle?
  2. Using date in a check constraint, Oracle
  3. Formatting DATE in oracle
  4. Convert epoch to date in sqlplus / Oracle
  5. Oracle: how to add minutes to a timestamp?
  6. Valid Date Checks in Oracle
  7. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  8. How to convert “1985-02-07T00:00:00.000Z” (ISO8601) to a date value in Oracle?
  9. What is the replacement of cursor foreach in oracle pl/sql?
  10. send a mail if count (*) >0 in oracle
  11. What is the difference between varchar and varchar2 in Oracle?
  12. PL/SQL, how to escape single quote in a string?
  13. Passing an array of data as an input parameter to an Oracle procedure
  14. What is the difference between “AS” and “IS” in an Oracle stored procedure?
  15. Boolean Field in Oracle
  16. Split function in oracle to comma separated values with automatic sequence
  17. ORA-06508: PL/SQL: could not find program unit being called
  18. How to handle to_date exceptions in a SELECT statment to ignore those rows?
  19. How to return a resultset / cursor from a Oracle PL/SQL anonymous block that executes Dynamic SQL?
  20. Difference between VARCHAR2(10 CHAR) and NVARCHAR2(10)
  21. HIbernate issue with Oracle Trigger for generating id from a sequence
  22. Why cannot I use bind variables in DDL/SCL statements in dynamic SQL?
  23. Using Alias in query resulting in “command not properly ended”
  24. Is it possible to kill a single query in oracle without killing the session?
  25. Get the LENGTH of a LONG RAW
  26. MySQL equivalent of ORACLES rank()
  27. Reading clob line by line with pl\sql
  28. Oracle: Days between two date and Exclude weekdays how to handle negative numbers
  29. Difference between LockModeType Jpa
  30. No more data to read from socket

Leave a Comment