[PHP] SELECT DAYOFYEAR(NOW())

Hi! I'm storing a date in this format : 2002-01-13 11:08:40 -mm-dd hh:mm:ss This is great because it gives me the date and the time, which I need. I want to compare this date from the database to the current DAYOFYEAR() but when I do this select DAYOFYEAR('2002-01-13 11:08:40') I get this

Re: [PHP] SELECT DAYOFYEAR(NOW())

This doesn't appear to be a PHP question. Are you sure you are on the right list? On Sun, 13 Jan 2002, sundogcurt wrote: Hi! I'm storing a date in this format : 2002-01-13 11:08:40 -mm-dd hh:mm:ss This is great because it gives me the date and the time, which I need. I want to

Re: [PHP] SELECT DAYOFYEAR(NOW())

I am a dork! And you answered that almost before I sent it, you're like Mighty Mouse on Ginseng! [EMAIL PROTECTED] wrote: This doesn't appear to be a PHP question. Are you sure you are on the right list? On Sun, 13 Jan 2002, sundogcurt wrote: Hi! I'm storing a date in this format :