How to convert a strings representing "yyyyMMdd HHmm" into a time stamp format
Tetsuro_W
Partner, Registered Posts: 4 Partner
Hi experts,
I have a sample date obtained from my customer that contains a string data like for example "20240310 1334".
This indicates time stamp date, so I want to convert this text string data into a time stamp data like "2024-03-10 13:34:00.000000"
Could someone please advise if any way to do this? Any commento will be appreciated.
Thanks in advance.
Best Answer
-
LouisDHulst Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Neuron, Registered, Neuron 2023 Posts: 54 Neuron
Hi @Tetsuro_W
,The Prepare visual recipe has a Parse Date processor that can handle this kind of operation (doc).
You would have to create the Prepare recipe, then select the Parse Date processor and use the custom format yyyyMMdd HHmm to get a parsed timestamp.
Answers
-
Hi @LouisDHulst
,Thanks for your comment! It worked!