troubleshooting Question

Help with GREATEST

Avatar of JElster
JElsterFlag for United States of America asked on
MySQL Server
8 Comments2 Solutions179 ViewsLast Modified:
Hi..
I'm using the greatest function on a series of dates.
It return the greatest in a wierd non data format

greatest(pci.updateddate,a.updateddate,dt.lastupdated) as LASTUPDATED

These fields are all datetime.

I get  values like
'-20130321134745'
'-20130321123715'

How can I format them as datetime?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros