如何从日期获取星期几名称? [英] How to get the week day name from a date?

问题描述

给出03/09/1982我们怎么能说是星期几.在这种情况下，它将为Tue.

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

(请注意，查询使用的是ANSI日期文字，该文字遵循ISO-8601日期标准，并避免了日期格式的歧义.)

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

这篇关于如何从日期获取星期几名称?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！