How to truncate DateTime to minutes in DW?

Question

Looking for a way to truncate a timestamp DateTime value (e.g. result of now()) to minutes with preserving the time zone i.e. something like this:

From: |2023-10-04T10:48:07.975905Z|

To: |2023-10-04T10:48:00.000000Z|

This of course can be done by first transforming DateTime to String, then applying string manipulations and then transforming back to DateTime. But it would be quite ugly, I guess.

So, looking for more elegant way of achieving this result.

Mule provides the similar function atBeginningOfHour that's doing truncation on an hour level.
I'm looking for a similar function but for minutes.

Mule DW version is 2.4.0 (the latest).

Creating it as string and appending seconds is not that ugly in your case. infact the ootb function atBeginningOfHour that you mention uses exactly that — Harshank Bansal
– Harshank Bansal, Commented Oct 4, 2023 at 6:38
@HarshankBansal, can you pls point me to where I can have a look at the "atBeginningOfHour" source code? — Vlad K
– Vlad K, Commented Oct 5, 2023 at 0:22
I just do a ctrl+click on the method name when writing dataweave in Anypoint studio — Harshank Bansal
– Harshank Bansal, Commented Oct 5, 2023 at 1:08

aled · Accepted Answer · 2023-10-05 01:48:10Z

1

A solution using periods to subtract seconds. I cheated a little bit using string interpolation to combine seconds and nanoseconds. It could be replaced with a mathematical expression but I think the intention may not be as clear. I used the seconds() function of the Periods module that was introduced in Mule 4.4 to simplify creating the periods to be subtracted from the original time.

fun truncateAtMinutes(t)=t - dw::core::Periods::seconds("$(t.seconds).$(t.nanoseconds)" as Number) 
---
truncateAtMinutes(|2023-10-04T10:48:07.975905-03:00|)

Output:

|2023-10-04T10:48:00-03:00|

edited Oct 5, 2023 at 1:48

answered Oct 4, 2023 at 2:54

aled

26.5k4 gold badges36 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Vlad K Over a year ago

Thanks for the idea. I've made it slightly simpler, as no need in importing the Periods module.

aled Over a year ago

I removed the import by using the full module name.

Vlad K · Accepted Answer · 2023-10-04 05:34:57Z

0

The variation of the aled's version but without using import:

fun atBeginningOfMinute(t: DateTime):DateTime = 
 t-('PT$(t.seconds).$(t.nanoseconds)S' as Period)

edited Oct 4, 2023 at 5:34

answered Oct 4, 2023 at 5:15

Vlad K

2,9115 gold badges38 silver badges61 bronze badges

3 Comments

aled Over a year ago

That was my first approach but I tried to avoid string conversions as much as possible. Note that your answer is missing subtracting the minutes. This is method is valid for Mule 4.3 and earlier versions since it doesn't depends on the new functions introduced in Mule 4.4.

Vlad K Over a year ago

@aled, there is no need in subtracting minutes. If I had a need in subtracting the minutes as well, I would just use the function "atBeginningOfHour" which is doing exactly that. So, you may wish to fix your code because it's a bit confusing now as there is no need in coding a custom function to achieve what your code is doing.

aled Over a year ago

I may have misread that in the question.

Collectives™ on Stack Overflow

How to truncate DateTime to minutes in DW?

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related