# Explain the results of ceiling Dates?

**URL:** <https://discourse.julialang.org/t/explain-the-results-of-ceiling-dates/44553>\
**Category:** Data\
**Tags:** dates\
**Created:** [August 8, 2020, 8:09am UTC](https://discourse.julialang.org/t/explain-the-results-of-ceiling-dates/44553 "2020-08-08T08:09:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![bigdataman2015](https://avatars.discourse-cdn.com/v4/letter/b/e99b99/32.png) [@bigdataman2015](https://discourse.julialang.org/u/bigdataman2015)\
**Post date:** [August 8, 2020, 8:09am UTC](https://discourse.julialang.org/t/explain-the-results-of-ceiling-dates/44553/1 "2020-08-08T08:09:00Z")

</div>

julia\> using Dates

julia\> ceil(DateTime(2013, 2, 13, 0, 31, 24), Dates.Minute(15))  
2013-02-13T00:45:00

julia\> ceil(DateTime(2013, 2, 13, 0, 31, 24), Dates.Minute(16))  
2013-02-13T00:32:00

julia\> ceil(DateTime(2013, 2, 13, 0, 31, 24), Dates.Minute(17))  
2013-02-13T00:33:00

julia\> ceil(DateTime(2013, 2, 11, 0, 31, 24), Dates.Minute(17))  
2013-02-11T00:40:00

# in R

> library(lubridate)  
> ceiling\_date(ymd\_hms(“2013-02-13 00:31:24”), “15 mins”)  
> [1] “2013-02-13 00:45:00 UTC”  
> ceiling\_date(ymd\_hms(“2013-02-13 00:31:24”), “16 mins”)  
> [1] “2013-02-13 00:32:00 UTC”  
> ceiling\_date(ymd\_hms(“2013-02-13 00:31:24”), “17 mins”)  
> [1] “2013-02-13 00:34:00 UTC”  
> ceiling\_date(ymd\_hms(“2013-02-11 00:31:24”), “17 mins”)  
> [1] “2013-02-11 00:34:00 UTC”

explain the results of ceiling Dates ? thanks!

---

<div class="post-metadata">

**Author:** ![quinnj](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/quinnj/32/11_2.png) [@quinnj](https://discourse.julialang.org/u/quinnj)\
**Post date:** [September 3, 2020, 2:36am UTC](https://discourse.julialang.org/t/explain-the-results-of-ceiling-dates/44553/2 "2020-09-03T02:36:44Z")

</div>

Looks like a bug to me; mind opening an issue at [JuliaLang/julia](https://github.com/JuliaLang/julia/issues)?

---

<div class="post-metadata">

**Author:** ![MarcMush](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/marcmush/32/18006_2.png) [@MarcMush](https://discourse.julialang.org/u/MarcMush)\
**Post date:** [September 25, 2020, 8:41am UTC](https://discourse.julialang.org/t/explain-the-results-of-ceiling-dates/44553/3 "2020-09-25T08:41:00Z")

</div>

Julia doesn’t round based on the day you want but starting on `0000-01-01T00:00:00`

[https://docs.julialang.org/en/v1/stdlib/Dates/#Rounding-Epoch](https://docs.julialang.org/en/v1/stdlib/Dates/#Rounding-Epoch)

What you want is probably something like that

```julia
julia> ceil(Time(0,31, 24), Minute(16))

```

but it is not defined

you can try

```julia
julia> ceil(Time(0, 31, 24) - Time(0), Minute(17))

```

---

<div class="post-metadata">

**Author:** ![bigdataman2015](https://avatars.discourse-cdn.com/v4/letter/b/e99b99/32.png) [@bigdataman2015](https://discourse.julialang.org/u/bigdataman2015)\
**Post date:** [September 25, 2020, 10:17am UTC](https://discourse.julialang.org/t/explain-the-results-of-ceiling-dates/44553/4 "2020-09-25T10:17:49Z")

</div>

until now I deal with date or time data using R. Anyway, thanks! it is very kind of you!