|
|
Posted by Virginner on 10/12/07 00:13
"Mad Hatter" <colin@class31.co.uk> wrote in message
news:emsz5m7dx3wa$.1sbfzo9srgret.dlg@40tude.net...
>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?
DATE() does not take any parameters - you're getting confused with PHP's
date, or SQL's DATE_FORMAT
TIME() only returns the time of day
Are you sure you have the dob as a Unix Timestamp? That would be weird.
Now for example would be "1192147732" in Unix Time.
It's more likely you have the dob as a DATE column-type, e.g. 1943-12-31
It that's the case, then use:
SELECT numberx FROM member WHERE DAYOFYEAR(dob)=DAYOFYEAR(NOW())
Have fun.
Navigation:
[Reply to this message]
|