Convert CHAR to DATETIME
Posted on 2014-02-13
I've got a simple select statement that pulls columns from two tables using an Inner Join.
One of the columns is a key that represents the entry date and time we had to set it CHAR(14) because it wouldn't allow a key to be DATETIME.
Having said that, we want that field to be formatted as such from the select statement.
I'm kinda new large SQL queries so I wondered what's the best way to accomplish this? From within the select statement or using some type of function that returns a value?
Thanks in advance,