convert String31 datetime format into datetime in julia

Question

i have a dataframe with Time colume wiht String31 format. how can i convert this foramt into datetime.

i use Datetime method but it raised an error::

str_1=data_raw.Time[1,:]
DateTime(str_1, "yyyymmdd HHMMSS")

Error:

MethodError: no method matching Int64(::Vector{String31})
Closest candidates are:
(::Type{T})(!Matched::AbstractChar) where T<:Union{Int32, Int64}
@ Base char.jl:51
(::Type{T})(!Matched::AbstractChar) where T<:Union{AbstractChar, Number}
@ Base char.jl:50
(::Type{T})(!Matched::BigInt) where T<:Union{Int128, Int16, Int32, Int64, Int8}
@ Base gmp.jl:36

Yoir date is in yyyy-mm-dd hh:mm:ss format did you try `str_1=data_raw.Time[1,:] DateTime(str_1, "yyyy-mm-dd HH:MM:SS")` — Paul Maxwell, Jun 03 '23 at 10:20
yes but same result :MethodError: no method matching Int64(::Vector{String31}) — erfanvahdat, Jun 03 '23 at 10:30
@PaulMaxwell i remove the **dateformat** and it convert it into Datetime Format, also i import DateTime like this : `import Dates.DateTime as Datetime`.. Thank. — erfanvahdat, Jun 03 '23 at 18:27

score 2 · Accepted Answer · answered Jun 03 '23 at 22:30

2

Do:

DateTime.(str_1, "yyyy-mm-dd HH:MM:SS")

(note the . before ( - it broadcasts DateTime over all elements of str_1)

answered Jun 03 '23 at 22:30

Bogumił Kamiński

66,844
3
80
107

convert String31 datetime format into datetime in julia

1 Answers1