search

p-parkinson / BDNE

MIT License
0 stars 0 forks source link

Retrieve Point data from a table column #13

Open hidonkey2018 opened 6 months ago

hidonkey2018 commented 6 months ago

Create a function to retieve column data from a table

hidonkey2018 commented 6 months ago

The build-in Julia Dates library seem doesn't support 'microseconds'

Take 1 update time of a Point like: 2024-04-19T12:27:28.003276

using Dates
dfmt = DateFormat("yyyy-mm-ddTHH:MM:SS.ssssss")
DateTime("2024-04-19T12:27:28.003276",dfmt) #fails

The current solution is trim the nanosecond part, ie: 2024-04-19T12:27:28.003276 -> 2024-04-19T12:27:28.003

Ref: https://discourse.julialang.org/t/simple-method-for-converting-float-array-to-datetime-or-similar/71621/6