Forward Xu created CALCITE-2995: ----------------------------------- Summary: Add the DAYNAME,MONTHNAME function Key: CALCITE-2995 URL: https://issues.apache.org/jira/browse/CALCITE-2995 Project: Calcite Issue Type: New Feature Reporter: Forward Xu
MONTHNAME(date) Returns the full name of the month for date. The language used for the name is controlled by the value of the lc_time_names system variable. SQL: {code:java} SELECT MONTHNAME('2018-01-01') monthname;{code} Result: ||monthname|| |January| DAYNAME(date) Returns the name of the weekday for date. The language used for the name is controlled by the value of the lc_time_names system variable. SQL: {code:java} SELECT DAYNAME('2018-01-01') dayname;{code} Result: ||dayname|| |Monday| -- This message was sent by Atlassian JIRA (v7.6.3#76005)