MONTH - Amazon Glue DataBrew
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

MONTH

Creates a new column containing the number of the month, from a string that represents a date.

Parameters

  • sourceColumn – The name of an existing column.

  • value – A character string to evaluate.

  • targetColumn – A name for the newly created column.

Note

You can specify either sourceColumn or value, but not both.

Example

{
    "RecipeAction": {
        "Operation": "MONTH",
        "Parameters": {
            "value": "2018-05-27",
            "targetColumn": "MONTH Column 1"
        }
    }
}