After I import the file, there is a column:
I want to calculate a new column to convert the column above to seconds, how can I do that?
Friday - last edited Friday
Is your datetime variable a numeric one just formatted with datetime format or is it a char?
If it is formatted, remove the format , you will see the number of seconds since January 1, 1960.
Or if you are looking to extract seconds from the datetime value, use second function
It is not numeric, it is char. This is the reason I cannot convert them into seconds.
Still better: use the datetime18. informat when reading the external file..