/bundles/itninjaweb/img/Breadcrumb_cap_w.png

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   [ - ] Hide Comment

Comments

  • I know this is an old topic, however can I get some clarification on this, as I am trying to do the samething..

    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......
Please log in to comment

Answer this question or Comment on this question for clarity

Answers

0

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