CONVERT_TIMEZONE - 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).

CONVERT_TIMEZONE

Converts a time value from the source column into a new column based on a specified timezone.

Parameters

  • sourceColumn – The name of an existing column. The source column can be of type string, date, or timestamp.

  • fromTimeZone – Source value timezone. If nothing is specified, the default timezone is UTC.

  • toTimeZone – Timezone to be converted to. If nothing is specified, the default timezone is UTC.

  • targetColumn – A name for the newly-created column.

  • dateTimeFormat – Optional. A format string for the date. If the format isn't specified, the default format is used: yyyy-mm-dd HH:MM:SS.

Example

{
    "RecipeAction": {
        "Operation": "CONVERT_TIMEZONE",
        "Parameters": {
            "sourceColumn": "DATETIME Column 1",
            "fromTimeZone": "UTC+08:00",
            "toTimeZone": "UTC+08:00",
            "targetColumn": "DATETIME Column CONVERT_TIMEZONE",
            "dateTimeFormat": "yyyy-mm-dd HH:MM:SS"
        }
    }
}