redshift transform year_month

MarkSnodgrass
MarkSnodgrass Portland, Oregon 🟤

I am trying to do some transforms within a Redshift Data Flow where I need the year and month from a date field in the form of YYYYMM so I can do some math with it. I thought I could use the extract(year_month from date) function, but I get the following error:

 

The database reported a syntax error. [Amazon](500310) Invalid operation: Invalid date part for DATEPART/EXTRACT: Details:<br>----------------------------------------------- error: Invalid date part for DATEPART/EXTRACT:<br> code: 8001 context: Invalid date part:year_month. query

 

Here's an example: 

 

SELECT extract(year_month from CURRENT_DATE);

 

What is the proper syntax for this? 

Comments

  • Hi,

    Is anyone able to help out with this request?


    Thanks,

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🟤

    I decided to go in a different direction and get the data in the format I needed in the workbench rather than in the dataflow