/build/static/layout/Breadcrumb_cap_w.png

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

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!

1 Comment   [ + ] Show comment
  • Can you post your query? I have date fields on one of my assets and it reports as yyyy-mm-dd. - chucksteel 5 years ago

Answers (2)

Answer Summary:
Posted by: HarborIT 5 years ago
Senior White Belt
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.
Posted by: aragorn.2003 5 years ago
Red Belt
0

Top Answer

You can use the DATE_FORMAT function

select DATE_FORMAT(DATE(FIELDNAME), '%d.%m.%Y') as Date from TABLE
 
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