Parsing dates
Is there any way to parse a date column without Hours, Minutes and Seconds? I specified the format like MM/dd/yyyy, however, it appears. For example, after parsing 12/30/1899, it is showed like 1899-12-30T00:00:00.000Z. I just want 1899-12-30 only.
Thanks for your attention.
Best Answer
-
Emma Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer Posts: 52 DataikerOptionsHey @rafael_rosado97
,No, there is no way to parse the date without including the hours, minutes, and seconds. If you do any formatting your DATE will become a STRING type.
If you do not mind the column becoming STRING type then you can achieve the formatting you want by adding one additional Prepare step called "Find and Replace" where you specify the parsed date column, the value you want to remove (in your case: T00:00:00.000) and no value in the Replacement. See the screenshot.
Hope that answers your question,
Emma
Answers
-
rafael_rosado97 Partner, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 58 PartnerOptions
It's very clear. Thank you for your prompt answer, @Emma