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