Posted by Mad Hatter on 10/11/07 21:55

I need to find out whos birthdays land today. The DOB is stored in a
standard Unix timestamp. I'm trying to use the following but it throws up a
syntax error.

SELECT numberx FROM member WHERE date('d m',dob)=date('d m',time())

Where am I going wrong?

• Next in forum: Re: What's wrong with this?
• Prev in forum: Re: Slow results
• Thread view: What's wrong with this?

[Reply to this message]