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! ...
  • mwegener's avatar
    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.