Forum Discussion

Jeanxyz's avatar
Jeanxyz
Power Participant
5 years ago
Solved

import datetime

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! ...
Need Help
  • mwegener's avatar
    mwegener
    5 years ago

    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.

     

     

mwegener's avatar
mwegener
Most Valuable Professional
5 years ago

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's avatar
Jeanxyz
Power Participant
5 years ago

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