Alternative to DATEDIFF in MySQL version 4.0
Adrienne Boswell
have DATEDIFF. I am asking the host to upgrade, but in the meantime, I
still need to get my query to work:
SELECT fields FROM table WHERE DATEDIFF(YYYY-MM-DD,NOW())>= 0
Are there alternatives? Please advise.
Thanks in advance.
--
Adrienne Boswell at Home
Arbpen Web Site Design Services
http://www.cavalcade-of-coding.info
Please respond to the group so others can share
Peter H. Coffin
> The host server I am using is MySQL version 4.0.27-standard, which does not
> have DATEDIFF. I am asking the host to upgrade, but in the meantime, I
> still need to get my query to work:
>
> SELECT fields FROM table WHERE DATEDIFF(YYYY-MM-DD,NOW())>= 0
>
> Are there alternatives? Please advise.
>
> Thanks in advance.
-- Not tested, but should give you the idea
SELECT fields FROM table
WHERE DATE_ADD(mydatecol, INTERVAL 1 MONTH) >= NOW();
gets you all the records in the past month.
http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html
Just watch the version numbers when features were added and you'll be
fine.
--
Because of the diverse conditions of humans, it happens that some acts are
virtuous to some people, as appropriate and suitable to them, while the same
acts are immoral for others, as inappropriate to them.
-- Saint Thomas Aquinas
Adrienne Boswell
<hel...@ninehells.com> writing in
news:slrnfo361n....@abyss.ninehells.com:
> On Mon, 07 Jan 2008 01:46:35 GMT, Adrienne Boswell wrote:
>> The host server I am using is MySQL version 4.0.27-standard, which
>> does not have DATEDIFF. I am asking the host to upgrade, but in the
>> meantime, I still need to get my query to work:
>>
>> SELECT fields FROM table WHERE DATEDIFF(YYYY-MM-DD,NOW())>= 0
>>
>> Are there alternatives? Please advise.
>>
>> Thanks in advance.
>
> -- Not tested, but should give you the idea
> SELECT fields FROM table
> WHERE DATE_ADD(mydatecol, INTERVAL 1 MONTH) >= NOW();
>
> gets you all the records in the past month.
Yup, works fine for February on, but no joy for anything in January.
>
> http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html
>
> Just watch the version numbers when features were added and you'll be
> fine.
>
--
Paul Lautman
> Gazing into my crystal ball I observed "Peter H. Coffin"
> <hel...@ninehells.com> writing in
> news:slrnfo361n....@abyss.ninehells.com:
>
>> On Mon, 07 Jan 2008 01:46:35 GMT, Adrienne Boswell wrote:
>>> The host server I am using is MySQL version 4.0.27-standard, which
>>> does not have DATEDIFF. I am asking the host to upgrade, but in the
>>> meantime, I still need to get my query to work:
>>>
>>> SELECT fields FROM table WHERE DATEDIFF(YYYY-MM-DD,NOW())>= 0
>>>
>>> Are there alternatives? Please advise.
>>>
>>> Thanks in advance.
>>
>> -- Not tested, but should give you the idea
>> SELECT fields FROM table
>> WHERE DATE_ADD(mydatecol, INTERVAL 1 MONTH) >= NOW();
>>
>> gets you all the records in the past month.
>
> Yup, works fine for February on, but no joy for anything in January.
>
>>
>> http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html
>>
>> Just watch the version numbers when features were added and you'll be
>> fine.
Can you post exactly what you are trying to do?
DATEDIFF(YYYY-MM-DD,NOW())
is not a valid expression.
Assuming that your YYYY-MM-DD actually refers to a date ot datetime column,
what is wrong with just doing
YYYY-MM-DD >= NOW()
Adrienne Boswell
<paul.l...@btinternet.com> writing in
news:5uev6uF...@mid.individual.net:
Wow! It worked. I must have had something wrong in my original query.
Thank you for hitting me on the head with the obvious!
Paul Lautman
>
> Wow! It worked. I must have had something wrong in my original
> query. Thank you for hitting me on the head with the obvious!
Hope it didn't hurt too much!
Adrienne Boswell
@mid.individual.net:
Nah, it only hurts in public ... <science fiction style music>You can't
feel anything in Usenet</science fiction style music>