I have a data source where the dates come back like this:
How can I display this better? It doesn't actually have to be converted technically, this is just for reporting. Ideally it would output
2015-06-14 2:05 PM (EST) but I also want the statement to be as simple as possible so the timezone offset and 12hr time are optional.
CAST ('20150614140520-0500' As Date) but it returns
I also tried
CAST (LEFT('20150614140520-0500',14) As Date) as well as some other variants without luck.