Here are the examples of Oracle SQL queries to get the day from date.
SQL Query to Get Full Day Name from the Date
select to_char(sysdate, 'DAY') full_name from dual;
Output:
SUNDAY
To Get Short Day Name
select to_char(sysdate, 'DY') short_name from dual;
Output:
SUN
To Get Day of the Week
select to_char(sysdate, 'D') dayOfWeek from dual;
Output:
1
Leave a comment
You must login or register to add a new comment.