redshift transform year_month

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? 

**Check out my Domo Tips & Tricks Videos

**Make sure to <3 any users posts that helped you.
**Please mark as accepted the ones who solved your issue.

Comments

  • Hi,

    Is anyone able to help out with this request?


    Thanks,

  • 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

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.