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