# Convert Date Values to Dates.DateTime

**URL:** <https://discourse.julialang.org/t/convert-date-values-to-dates-datetime/95541>\
**Category:** General Usage\
**Tags:** question, dates\
**Created:** [March 4, 2023, 1:22pm UTC](https://discourse.julialang.org/t/convert-date-values-to-dates-datetime/95541 "2023-03-04T13:22:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![lukas\_r](https://avatars.discourse-cdn.com/v4/letter/l/f6c823/32.png) [@lukas\_r](https://discourse.julialang.org/u/lukas_r)\
**Post date:** [March 4, 2023, 1:22pm UTC](https://discourse.julialang.org/t/convert-date-values-to-dates-datetime/95541/1 "2023-03-04T13:22:42Z")

</div>

I have date information coming from a sensor thats formatted as i = 8304.621828703705. Is there a way to easily convert this to a DateTime? I can get a Date (yy-mm-dd) out of it using Date(Dates.UTD(round(i))), however I really need a DateTime (yyyymmdd HHMMSS).

---

<div class="post-metadata">

**Author:** ![rocco\_sprmnt21](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/rocco_sprmnt21/32/20127_2.png) [@rocco\_sprmnt21](https://discourse.julialang.org/u/rocco_sprmnt21)\
**Post date:** [March 4, 2023, 6:01pm UTC](https://discourse.julialang.org/t/convert-date-values-to-dates-datetime/95541/2 "2023-03-04T18:01:11Z")

</div>

There are likely to be more direct and idiomatic ways of accomplishing this, but see if the following lines inspire you.

```julia
julia> t=now()
2023-03-04T18:56:54.720

julia> Dates.value(t)
63813639414720

julia> Dates.UTM(Dates.value(t))
Dates.UTInstant{Millisecond}(Millisecond(63813639414720))

julia> DateTime(Dates.UTM(Dates.value(t)))       
2023-03-04T18:56:54.720

julia> round(Dates.value(t)/(1000*24*60*60))     
738584.0

julia> Dates.UTD(round(Dates.value(t)/(1000*24*60*60)))
Dates.UTInstant{Day}(Day(738584))

julia> Date(Dates.UTD(Dates.value(t)))
174715810495-12-31

```

```julia

i = 8304.621828703705 # if these are days, in milliseconds they do

DateTime(Dates.UTInstant(Dates.Millisecond(round(i*1000*24*60*60)))) # 0023-09-26T14:55:26
# maybe floor instead round is better

round(i*1000*24*60*60) ≈ Dates.value(DateTime("0023-09-26T14:55:26")) #true

```

---

<div class="post-metadata">

**Author:** ![lukas\_r](https://avatars.discourse-cdn.com/v4/letter/l/f6c823/32.png) [@lukas\_r](https://discourse.julialang.org/u/lukas_r)\
**Post date:** [March 5, 2023, 7:12am UTC](https://discourse.julialang.org/t/convert-date-values-to-dates-datetime/95541/3 "2023-03-05T07:12:04Z")

</div>

The conversion in the last part did the Trick, thanks!