SyntaxFix

[oracle] How to get the week day name from a date? 

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.)

Examples related to oracle

• concat yesterdays date with a specific time • ORA-28001: The password has expired • how to modify the size of a column • How to create a blank/empty column with SELECT query in oracle? • Find the number of employees in each department - SQL Oracle • Query to display all tablespaces in a database and datafiles • When or Why to use a "SET DEFINE OFF" in Oracle Database • How to insert date values into table • error: ORA-65096: invalid common user or role name in oracle • In Oracle SQL: How do you insert the current date + time into a table?

Examples related to date

• How do I format {{$timestamp}} as MM/DD/YYYY in Postman? • iOS Swift - Get the Current Local Time and Date Timestamp • Typescript Date Type? • how to convert current date to YYYY-MM-DD format with angular 2 • SQL Server date format yyyymmdd • Date to milliseconds and back to date in Swift • Check if date is a valid one • change the date format in laravel view page • Moment js get first and last day of current month • How can I convert a date into an integer?

Examples related to dayofweek

• How to get the integer value of day of week • How to get the week day name from a date? • How to get the day of week and the month of the year? • How to group by week in MySQL?