DAYNAME

​

Syntax

​

Scalar

dayname(value)

​

Arguments

​

Returns

• Type: STRING
• Possible values: Sun, Mon, Tue, Wed, Thu, Fri or Sat.
• NULL behavior: Returns NULL for NULL input.

​

Properties

​

Usage notes

• Timezone-bearing timestamps use their local calendar day; the test maps a UTC Friday to Saturday in Pacific/Auckland.

​

Examples

​

Thursday

SELECT dayname(DATE '2009-07-30') AS result;

​

NULL input

SELECT dayname(CAST(NULL AS DATE)) AS result;

​

Limitations

• Use the date/time types listed above. STRING input is outside this form.