[ https://issues.apache.org/jira/browse/CALCITE-2995?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Forward Xu updated CALCITE-2995: -------------------------------- 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: {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 system time config. SQL: {code:java} SELECT DAYNAME('2018-01-01') dayname;{code} Result: ||dayname|| |Monday| was: 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| > 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 > Assignee: Forward Xu > Priority: Major > > 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: > {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 system time config. > SQL: > {code:java} > SELECT DAYNAME('2018-01-01') dayname;{code} > Result: > ||dayname|| > |Monday| -- This message was sent by Atlassian JIRA (v7.6.3#76005)