需要在SQL中显示时间戳中的星期几

SELECT CASE WEEKDAY(timestamp_column)
       WHEN 0 THEN '星期一'
       WHEN 1 THEN '星期二'
       WHEN 2 THEN '星期三'
       WHEN 3 THEN '星期四'
       WHEN 4 THEN '星期五'
       WHEN 5 THEN '星期六'
       WHEN 6 THEN '星期日'
       END AS weekday
FROM your_table;

SELECT CASE EXTRACT(DOW FROM timestamp_column)
       WHEN 0 THEN '星期日'
       WHEN 1 THEN '星期一'
       WHEN 2 THEN '星期二'
       WHEN 3 THEN '星期三'
       WHEN 4 THEN '星期四'
       WHEN 5 THEN '星期五'
       WHEN 6 THEN '星期六'
       END AS weekday
FROM your_table;

SELECT TO_CHAR(timestamp_column, 'Day') AS weekday
FROM your_table;