Check out the first Dataiku 8 Deep Dive focusing on Productivity on October 29th Read More

Parsing Dates in the Second SQL Prepare Recipe Hands On

Level 7
Parsing Dates in the Second SQL Prepare Recipe Hands On

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

 

--Tom
2 Replies
Dataiker
Dataiker

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

0 Kudos
Level 7
Author

Thanks.

--Tom
0 Kudos