Community Conundrum 27: Stacks of Questions is live! Read More

String dates to datetime format

Level 2
String dates to datetime format

Hello, is there a way to convert string dates to datetime format? For example Jan-18 to '01-2018'?

I know sql has TO_DATE( '10 Aug 2018', 'DD MON YYYY' )

But is there something similar available for dataiku?

2 Replies
Dataiker
Dataiker

Hi @vho 

Yes, indeed. When you have your dataset on the flow, you can use a Prepare recipe. Inside of it, you'll be able to perform many transformations. One of them is the parsing of dates from string into a datetime. 

The system will suggest formats based on your sample data, but you can override, or add additional formats in case the column contains several.

Hope this helps!

Neuron
Neuron

@vho 

You might want to look in the prepare recipe.  In particular, at the date parse step.  

This short training video will give you an overview. 

https://academy.dataiku.com/visual-recipes-overview/479166

 

 

--Tom