How to convert a string timestamp to timestamp datatype column?

[rushi-jariwala]

I have a timestamp column in string, something like this:

I want to cast this to timestamp column. I am unable to find any documentation on this.

I tried this, but it did not work. Output is None.
df = df.with_column('timestamp1',col('timestamp').cast(DataType.timestamp('us')))

[samster25]

@kevinzwang, can you spec out an expression for converting strings and other types into a TimeStamp. Similar to https://pandas.pydata.org/docs/reference/api/pandas.to_datetime.html

[kevinzwang]

Will do! I was just thinking about this recently

[kevinzwang]

I'll be tracking progress on this at #2302