import datetime

[Jeanxyz]

Hi,

I'm importing data from an csv file, there is a column showing date, time and time zone information.

This column is loaded as text, how can I convert it into date time format?

Thanks!

[mwegener · Accepted solution]

Hi @Jeanxyz ,

you can change the data type using the data type icon in the column header.

I don't know how important the time zone is, you should remove it beforehand. Extract the first 19 characters.

[Jeanxyz]

Thanks, it works! I didn't realize that time zone information is causing the problem.