K1000 Reporting Date as mm/dd/yyyy 00:00:00
04/30/2015 1935 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 Chosen by the Author
Please log in to answer
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