Given 03/09/1982
how can we say it is which week day. In this case it will be Tue
.
Is it possible to get in a single query?
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.)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With