[CALCITE-2995] Add the DAYNAME，MONTHNAME function

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.21.0
• Labels: pull-request-available
• Assignee: Forward Xu
• Reporter: Forward Xu
• Created: 14/Apr/19 04:31
• Updated: 10/Sep/19 21:37
• Resolved: 10/Jul/19 03:53

Description

MONTHNAME(date)
Returns the full name of the month for date. The language used for the name is controlled by the system time config.

SQL:

SELECT MONTHNAME('2018-01-01') monthname;

Result:

monthname
January

DAYNAME(date)
Returns the name of the weekday for date. The language used for the name is controlled by the system time config.

SQL:

SELECT DAYNAME('2018-01-01') dayname;

Result:

dayname
Monday

Issue Links

• links to: GitHub Pull Request #1163