Parsing Dates in the Second SQL Prepare Recipe Hands On

Options
tgb417
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,595 Neuron
edited July 16 in Academy Discussions

I'm finding the parsing of dates in the Second SQL Hands-On Prepare Recipe to be a bit odd.

https://academy.dataiku.com/dataiku-dss-sql-1/500835

In the video I see that the Date format(s) selected was

yyyy/HH/mm (Year/Hour in day/Minute in hour)

In my mind birthdays are typically:

yyyy/MM/dd (Year/Month in year/Day in month)

And in fact, when I choose the format that makes sense to me there are four records that do not parse for Leap year problems.

[11:21:16] [WARN] [dku.shaker.date] - SHAKER_BAD_DATE: Failed to parse '1965/2/29' using format 'yyyy/MM/dd': Cannot parse "1965/2/29": Value 29 for dayOfMonth must be in the range [1,28]
[11:21:16] [WARN] [dku.shaker.date] - SHAKER_BAD_DATE: Failed to parse '1965/2/29' using format 'yyyy/MM/dd': Cannot parse "1965/2/29": Value 29 for dayOfMonth must be in the range [1,28]
[11:21:16] [WARN] [dku.shaker.date] - SHAKER_BAD_DATE: Failed to parse '1993/2/29' using format 'yyyy/MM/dd': Cannot parse "1993/2/29": Value 29 for dayOfMonth must be in the range [1,28]
[11:21:16] [WARN] [dku.shaker.date] - SHAKER_BAD_DATE: Failed to parse '1993/2/29' using format 'yyyy/MM/dd': Cannot parse "1993/2/29": Value 29 for dayOfMonth must be in the range [1,28]
[11:21:16] [WARN] [dku.shaker.date] - SHAKER_BAD_DATE: Failed to parse '1993/2/29' using format 'yyyy/MM/dd': Cannot parse "1993/2/29": Value 29 for dayOfMonth must be in the range [1,28]

Is this a thing? Are there places in the world that show birthdates as:

(Year/Hour in day/Day in Month)?

Below is a frame from the video:

DateTime Format.jpg

Answers

  • Alex_Reutter
    Alex_Reutter Alpha Tester, Dataiker Alumni, Dataiku DSS Core Designer Posts: 105 ✭✭✭✭✭✭✭
    Options

    Hi! That's an error in the video and it should be yyyy/MM/dd. Thanks for catching this.

  • tgb417
    tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,595 Neuron
    Options
Setup Info
    Tags
      Help me…