Changing date format for Dell Kace reports
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?
1 Comment
[ + ] Show comment
Answers (1)
Please log in to answer
Posted by:
grayematter
10 years ago
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
This is MySQL query: (also where I have put the DATE_FORMAT command, however doesn't work.)
SELECT HD_TICKET.ID, DATE_FORMAT(HD_TICKET.CREATED, '%d/%m/%Y'), S.FULL_NAME AS SUBMITTER_NAME, HD_TICKET.TITLE FROM HD_TICKET LEFT JOIN USER S ON (S.ID = HD_TICKET.SUBMITTER_ID) LEFT JOIN USER O ON (O.ID = HD_TICKET.OWNER_ID) WHERE (HD_TICKET.HD_QUEUE_ID = 7) AND ((( date(HD_TICKET.CREATED) >= date_sub(date_sub(curdate(), interval dayofmonth(curdate())-1 day), interval 1 month) and date(HD_TICKET.CREATED) < date_sub(curdate(), interval dayofmonth(curdate())-1 day) ) ) AND...... - hefty_merv 7 years ago