DATE_FORMAT
I have the following query. I want to format the Acquisition Date to display in UK format without showing the time. For example, today would be 27/05/2009.
SELECT resFields.UDF_CHAR2 'Asset Location',resource.ASSETTAG 'Asset Tag', resource.SERIALNO 'Serial Number',product.COMPONENTNAME 'Product',LONGTODATE(resource.ACQUISITIONDATE) 'Acquisition Date', resourcecost.cost 'Purchase Price' FROM Resources resource
LEFT JOIN ComponentDefinition product ON resource.COMPONENTID=product.COMPONENTID
LEFT JOIN Resource_Fields resFields ON resource.RESOURCEID=resFields.RESOURCEID
LEFT JOIN ResourceCost ON Resource.RESOURCEID = ResourceCost.RESOURCEID
WHERE (((resFields.UDF_CHAR2 != 'DISPOSAL') AND (resFields.UDF_CHAR2 != 'STOLEN')) OR (resFields.UDF_CHAR2 IS NULL))
ORDER BY resFields.UDF_CHAR2, resource.ASSETTAG
LEFT JOIN ComponentDefinition product ON resource.COMPONENTID=product.COMPONENTID
LEFT JOIN Resource_Fields resFields ON resource.RESOURCEID=resFields.RESOURCEID
LEFT JOIN ResourceCost ON Resource.RESOURCEID = ResourceCost.RESOURCEID
WHERE (((resFields.UDF_CHAR2 != 'DISPOSAL') AND (resFields.UDF_CHAR2 != 'STOLEN')) OR (resFields.UDF_CHAR2 IS NULL))
ORDER BY resFields.UDF_CHAR2, resource.ASSETTAG
Can you please help me with the syntax? Whenever I try using the DATE_FORMAT function in conjunction with LONGTODATE I get a string out of range error.