I am trying to format my dates correctly using the TO_TIMESTAMP function however it is only correctly formatting some of the dates and others are remaining null.
My text column I am trying to convert looks like Jan 31 2022 9:58AM +00:00 so I use TO_TIMESTAMP(Date_Column, ‘MON DD YYYY HH:MIPM TZO’, 1) which correctly formats the majority of the dates.
However any dates which have a single digit day are not getting formatted.
They look something like this Feb 6 2022 9:18AM +00:00.
How am I able to format this into a datetime column?