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 incase anybody else was having similar
trouble.
(C:
>From: "Curtis Gordon" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: DAYOFYEAR()
>Date: Mon, 14 Jan 2002 03:24:02 +0000
>
>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.
>
>
>
>
>_________________________________________________________________
>Join the world’s largest e-mail service with MSN Hotmail.
>http://www.hotmail.com
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail.
http://www.hotmail.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
