Hello. I was not able to find quite what I was lookig for in an answer via the experts-exchange solutions database or on the regular internet so I decided to submit a question to the experts.
I am developing a coldfusion page that displays query results from a access database that includes the date entry of records. The only problem is that the time is also being displayed with the date (for example: 2011-04-22 09:45:37:00). I would like to not have the time displayed and have tried to use substr or cast or convert or the trim functions within the sql query to no avail. Below is the <cfquery> that i'm using.
Your help is appreciated in advance.
<cfquery name="myrequests" datasource="srs">
select request, customer, opened_date from issues;