Re: FN-FORUM: SQL Help (probably an easy one)

date posted 16th January 2007 09:53

Hello

I tried this

SELECT *
FROM newmenudata
WHERE DATE_FORMAT(timeadded, '%b') = 'Jan'

Or something very similar.

http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html

Dave...

AND

WHERE Month(timeadded) = 1

With NO LUCK!

It says DATE_FORMAT and Month is not compatible.

I am so confused...

Anyway if anyone can tell me how I can query the first 3 letters of a column for
Example I want to get the first 3 letters of January to get Jan

Thanks for your help!