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 :
>>
>>2002-01-13 11:08:40
>>yyyy-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
>>
>>
>> Error - Perl execution failed
>>
>>Modification of non-creatable array value attempted, subscript -1 at ./mysql-lib.pl
>line 187, line 2.
>>
>>
>>
>>It works great when I do select DAYOFYEAR(NOW()) though, I'm totally
>>confused, is this a known bug or is there a work around that anybody
>>knows of that you can let me in on?
>>
>>Ulitmately I want to compare todays DAYOFYEAR to the DAYOFYEAR from
>>fields in the database to establish entries that were created "today".
>>
>>I'm looking at what I have written here and I think I have confused
>>myself, if this is not clear, please feel free to flame me.
>>
>>I'm looking forward to any light that can be shed on this problem.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
