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. >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >