Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Date conversion to Text
Added on May 27, 2021 3:15PM
Likes: 0
Replies: 3
Ankur5289
Partner, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered Posts: 27 Partner
i have some columns in date format and in Unix format . for example 2020-06-16T12:50:55.811Z
Now i need to convert these dates to text format like for the above example "20200616" as in YYYYMMDD format.
Is there any formulae to do that or any recipe?
Best Answer
-
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,618 NeuronWelcome to our community.
If I was using a visual recipe I'd likely use Format date with a custom format. I'd then use the format yyyyMMdd to get the results you are looking for. (Note: Case does matter. upper case Y and lowercase y mean two different things. So do upper case D and lower case d mean two different things.)
Here is some documentation on the Dataiku visual recipe feature.
The key thing is to use the Java Simple Date Format to say what you would like to see in your column.
I hope this helps a bit. And once again welcome to our community. Let us know how you get on with this.
Answers
-
CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,150 ✭✭✭✭✭✭✭✭✭Hey @Ankur5289
welcome to the Dataiku Community. While you wait for a more detailed response, you should be able to achieve this with the Prepare Recipe. Here is some information in our documentation about Managing Dates.I hope this helps!