|
|
Posted by Captain Paralytic on 10/12/07 09:04
On 11 Oct, 22:55, Mad Hatter <co...@class31.co.uk> wrote:
> 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?
In future, might I suggest that you post the text of the error!
Navigation:
[Reply to this message]
|