SQL Statement in Dataiku, not recognizing function

Noah
Noah Registered Posts: 43 ✭✭✭✭
in Using Dataiku

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

· Share on FacebookShare on Twitter

Answers

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

    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.

    · Share on FacebookShare on Twitter
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…