When you run any type of Dell Kace report that displays a date, it shows up as YYYY-DD-MM HH:MM:SS. Is there a way to change this format to something like Monthy, Day, Year? 

0 Comments   [ + ] Show Comments


Please log in to comment



You can edit the SQL for the query and use the DATE_FORMAT() function to format the date as appropriate.  Check the MySQL documentation for details:  http://dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html#function_date-format

Answered 06/05/2014 by: grayematter
Fifth Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity