Community Conundrum 10: The Titanic is now live Learn more

Change hour in date format

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
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
Level 2

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



 



0 Kudos
Labels (1)