/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


K1000 Reporting Date as mm/dd/yyyy 00:00:00

04/30/2015 2124 views
We have custom date fields under our asset types and when running reports with those field selected it reports as mm/dd/yyyy 00:00:00.  I would like to remove the timestamp at then end.  When running a 30+ page report, that is a LOT of extra 00:00:00 on the page.  I've tried editing the SQL with a FORMAT_DATE and CONVERT(VARCAHR but my MYSQL knowledge is not so good.  Any help would be greatly appreciated!
Answer Summary:
1 Comment   [ + ] Show comment

Comments

  • Can you post your query? I have date fields on one of my assets and it reports as yyyy-mm-dd.

Answer Chosen by the Author

0
You can use the DATE_FORMAT function

select DATE_FORMAT(DATE(FIELDNAME), '%d.%m.%Y') as Date from TABLE
Answered 05/07/2015 by: aragorn.2003
Red Belt

All Answers

This content is currently hidden from public view.
Reason: Removed by member request For more information, visit our FAQ's.
0
Sorry for the lack or response.  We were able to get what we wanted by using the DATE_FORMAT.  Example below:
DATE_FORMAT(ASSET_DATA_5.FIELD_10014,'%m/%d/%Y') AS PURCHASE_DATE
Worked good to get rid of the 00:00:00 off the report.
Answered 05/19/2015 by: HarborIT
Senior White Belt

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ