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.

     

     

2 Replies

  • 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.