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 |