Jump to content

How to roundup by next quarter minutes in Tibco BW 5.13


Obdurate -

Recommended Posts

We have a requirement to Round by the current date and time by quarter minutes, for example:

1. if current date time is 2020-05-28T10:01:00

then, round up tonext quarter to make it 2020-05-28T10:15:00

2. Aif current date time is 2020-05-28T10:15:01

then, round up tonext quarter to make it 2020-05-28T10:30:00

3. if current date time is 2020-05-28T10:46:15

then, round up tonext quarter to make it 2020-05-28T11:00:00

4. if current date time is 2020-12-31T23:47:00

then, round up to next quarter to make it2021-01-01T00:00:00

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...