Integrate Software AG Products Using Digital Event Services : MashZone NextGen Help : Appendix : Operators : Data transformation operators : Round up/down date : Examples
Examples
Source value
Accuracy
Result
2009-12-24T16:23
Day
2009-12-24
2009-12-24T16:23
Hour
2009-12-24T16
2009-12-24
Month
2009-12
2009-12-24
Quarter
2009-Q4
2009-12-24
Year
2009
Rounding
2010-08-06T17:15:27
10 seconds
2010-08-06T17:15:30
2010-08-06T17:07:00
15 minutes
2010-08-06T17:00
2010-08-06T17:18:00
15 minutes
2010-08-06T17:15
2010-08-06T02:18:04
4 hours
2010-08-06T04:00:00
Round up
Source value
Accuracy
Result
2010-02-28T23:07:00:00 AM
15 minutes
2010-02-28T23:00
2010-02-28T23:07:30
15 minutes
2010-02-28T11:15:00 PM
2010-02-28T23:30:00
1 hour
2010-03-01T00
Round down
Source value
Accuracy
Result
1970:01:01T09:00:01
6 hours
1970:01:01T12:00:00
1970:01:01T09:00:00
6 hours
1970:01:01T06:00:00
Always round up
Source value
Accuracy
Result
2010-02-28T11:15:00 PM
15 minutes
2010-02-28T11:15:00 PM
2010-02-28T11:15:01 PM
15 minutes
2010-02-28T11:30:00 PM
2010-02-28T20:00:01
6 hours
2010-03-01T00
Always round down
Source value
Accuracy
Result
2010-02-28T11:15:00 PM
15 minutes
2010-02-28T11:15:00 PM
2010-02-28T11:14:59 PM
15 minutes
2010-02-28T23:00
2010-03-01T05:59:59
6 hours
2010-03-01T00
Copyright © 2017 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback