[Resolved] Need Help With SQL Error

EDIT: Nevermind. The SQL statement that I was echoing out (in my quote below) was the wrong one. This was not the SQL statement that was causing the error. I fixed the problem, but I can't delete this post, so please disregard.

I'm getting this error with one of my scripts (note the SQL statement is included):

Quote:

---

SELECT DISTINCT DATE_FORMAT(postedOn, '%M 01, %Y') FROM vbsNews_news ORDER by postedOn DESC
An error has occurred in display.php:
You have an error in your SQL syntax near 'DATE_FORMAT(postedOn, '%m-%y') = '04-04'' at line 1

---

The SQL statement works perfectly fine on my local test machine (MySQL 3.23.58), but gives the above error on my remote server (MySQL 3.23.56).

I can't figure out what's causing it. Is it possible that I'm doing something that's not available until *.58? Or is there something I'm missing?