Incorrect parameter count in the call to native function 'DATE_FORMAT'
Hi, I'm pretty new to ColdFusion, and I was wondering if someone could give me a little help. I'm getting the following CF error: Incorrect parameter count in the call to native function 'DATE_FORMAT'
Here's the code that's producing it.
<cfquery name="qryGetDateName" datasource="DATABASE" result="RESULT">
SELECT DATE_FORMAT(Events.event_date,"%W") AS "Date"
WHERE event_id = 100
When I run this query separately on the database, it executes just fine, but it's giving me this error when I try to execute it from a ColdFusion file. Can anyone help me?