Forum Discussion

Astroraf's avatar
Astroraf
Data Pipeline
07-22-2024
Solved

Extract Date Format from Date Column using Extract?

I am trying to extract the DAY, MONTH, YEAR from a date column from my date column to create a dim_date table in my model.  Currently my code goes as follows: SELECT DISTINCT birthdate AS Date, Y...
  • gwolfe's avatar
    07-22-2024

    Hey Astroraf are you doing this in a custom table (green node in the elasticube)? If so the syntax is GETYEAR(yourdate),

    GETMONTH(yourdate),

    GETDAY(yourdate)