[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 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.
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 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. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 : 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 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.