MashZone NextGen 10.2 | 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 © 2013-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release