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

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

Please log in to comment

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

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