SQL Statement in Dataiku, not recognizing function

Options
Noah
Noah Registered Posts: 31 ✭✭✭✭

I am trying to return the YEAR and MONTH of a date in SQL using the YEAR and MONTH functions in a SQL recipe. For some reason YEAR is being registered but the DSS does not like MONTH.

Can someone help me troubleshoot why?

Thank you

Answers

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,727 Neuron
    Options

    Can you please show the error you get? Also what type of SQL Server do you use? SQL is a generic term, there are many different variants.

Setup Info
    Tags
      Help me…