I have a varchar column header (Prod_time) in the [YYYYmmdd hhmmss] format that I am trying to convert to datetime. I need to be able to pull data from a certain number of days, and I would like to be able to convert the varchar to datetime to facilitate this.
Is there a way to convert varchar to datetime? No special formatting of the datetime needed, only a data type conversion.
See Question&Answers more detail:os