The February release for the Community is live! Read More

Change hour in date format

Léa
Level 1
Change hour in date format
Hi,

I have the following format of date : 2016-01-15T01:00:00.000Z

I would like to change the 01 hour in 00, for all the dates. Does someone knows how to do it ?

Thank you,
0 Kudos
2 Replies
jereze
Dataiker
Dataiker

You can use the find and replace processor on a substring.



Or, you could use the inc function in a custom formula.

Jeremy, Product Manager at Dataiku
0 Kudos
Martin_Vlčko
Level 2

The best solution would be edit default timezone to fit your needs.



 



0 Kudos
Labels (1)
A banner prompting to get Dataiku DSS