[ https://issues.apache.org/jira/browse/CALCITE-2995?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Forward Xu reassigned CALCITE-2995: ----------------------------------- Assignee: Forward Xu > 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 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)