I am having a rough time trying to format the date on a CFChart (Flash Chart) on the X-axis. To fit all the dates in I what to shorten the date format to mm/dd but when I try to place the DATEFORMAT(dbvDate,'mm-dd') I get an error.
So I tried to format the date from my database (mySQL):
But when i do this i get the dates coming out like: "[B@11f75".
Any ideas?
So I tried to format the date from my database (mySQL):
Code:
SELECT DATE_FORMAT(timeStampStats, '%d %M') AS dbvDate
But when i do this i get the dates coming out like: "[B@11f75".
Any ideas?