How to convert Date and take a minimum date value based on the milliseconds

Tsurapaneni
Tsurapaneni Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Registered Posts: 41 ✭✭✭✭

Hi Team,

I have a date column in the database having the values like R-2020-03-04T09:23:43.234Z and I want to get the minimum date value of those values in the date column based on the milliseconds value. I AM USING AN IN DATABASE SQL Engine. Please let me know the possible working solutions there.

NOTE: I am using an in database SQL Engine.

Answers

  • Ignacio_Toledo
    Ignacio_Toledo Dataiku DSS Core Designer, 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: 412 Neuron

    Hi @Tsurapaneni
    ,

    To understand better your case, are you trying to use a "Prepare Recipe" with a database SQL Engine? Or is other kind of recipe you are talking about?

    And I'm not sure I understand what is the minimum you would like to get, could you provide a practical example?

    Cheers!

Setup Info
    Tags
      Help me…