DayName

Summary

The DayName function returns the day of the week for the given date.

Syntax

DayName(<date|date_time|instant|offset_date_time|zoned_date_time>)

Return Type

String

Details

Return values range from Sunday-Saturday

Examples

eval DayName(ToDate(‘2042-04-01’));

screen-shot-2016-09-21-at-9-17-33-am

select date1, DayName(date1), DayName(date_time1), DayName(offset_date_time1), DayName(zoned_date_time1) from AllTypes();

screen-shot-2016-09-21-at-9-17-25-am

Related Functions

DayOfMonth

DayOfWeek

DayOfYear

Month

MonthName

Week

Year