PROTECTED]>
>Reply-To: <[EMAIL PROTECTED]>
>To: "Curtis Gordon" <[EMAIL PROTECTED]>
>Subject: RE: DAYOFYEAR()
>Date: Mon, 14 Jan 2002 16:36:07 +1300
>
>Curtis,
>
>This is not a mysql issue ('Error - Perl execution failed')
>
>works fi
At 3:24 + 1/14/02, Curtis Gordon 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 compare this date from the database to the current DAYOFYEAR()
>
>but when I do this
I came up with my own work around, I am now storing the date and time
separately like this:
CURDATE(),CURTIME()
Then selecting my data with this WHERE statement:
WHERE DAYOFYEAR(CURDATE()) = DAYOFYEAR(mdate)
(mdate being the name of my CURDATE() field)
I just thought I would pass that on inc