MonthName

Summary

The MonthName function returns the month name for the specified date expression.

Syntax

MonthName(<date|date_time|instant|offset_date_time|zoned_date_time>)

Return Type

String

Details

The names of months are January through December.

Examples

eval MonthName(ToDate(‘2042-04-01’));

screen-shot-2016-09-21-at-9-53-49-am

 

select date1, MonthName(date1), MonthName(date_time1), MonthName(offset_date_time1), MonthName(zoned_date_time1) from AllTypes();

screen-shot-2016-09-21-at-9-53-44-am

Related Functions

DayName

DayOfMonth

DayOfWeek

DayOfYear

Month

Quarter

Week

Year