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 9 years ago
Answers (2)
Answer Summary:
Please log in to answer
Posted by:
HarborIT
9 years ago
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
9 years ago
Top Answer
You can use the DATE_FORMAT function
select DATE_FORMAT(DATE(FIELDNAME), '%d.%m.%Y') as Date from TABLE