How to convert a strings representing "yyyyMMdd HHmm" into a time stamp format

Options
Tetsuro_W
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
    LouisDHulst Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Neuron, Registered, Neuron 2023 Posts: 44 Neuron
    Answer ✓
    Options

    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

Setup Info
    Tags
      Help me…