Returns the specified part of a date as a string.
Syntax
DATENAME(unit, date)Example
Enter values below to update the example in real time.
order_id→order_date→day_name→orders→-- 요일 이름 반환
SELECT order_id, DATENAME(WEEKDAY, order_date) AS day_name
FROM orders;