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.
--
Adrienne Boswell at Home
Arbpen Web Site Design Services
http://www.cavalcade-of-coding.info
Please respond to the group so others can share

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.

http://dev.mysql.com/doc/refman/4.1/...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

Gazing into my crystal ball I observed "Peter H. Coffin"
<hellsop@ninehells.com> writing in
news:slrnfo361n.ih0.hellsop@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/...functions.html
>
> Just watch the version numbers when features were added and you'll be
> fine.
>



--
Adrienne Boswell at Home
Arbpen Web Site Design Services
http://www.cavalcade-of-coding.info
Please respond to the group so others can share

Adrienne Boswell wrote:
> Gazing into my crystal ball I observed "Peter H. Coffin"
> <hellsop@ninehells.com> writing in
> news:slrnfo361n.ih0.hellsop@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/...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()

Gazing into my crystal ball I observed "Paul Lautman"
<paul.lautman@btinternet.com> writing in
news:5uev6uF1hpothU1@mid.individual.net:

> Adrienne Boswell wrote:
>> Gazing into my crystal ball I observed "Peter H. Coffin"
>> <hellsop@ninehells.com> writing in
>> news:slrnfo361n.ih0.hellsop@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/...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()
>
>
>

Wow! It worked. I must have had something wrong in my original query.
Thank you for hitting me on the head with the obvious!

--
Adrienne Boswell at Home
Arbpen Web Site Design Services
http://www.cavalcade-of-coding.info
Please respond to the group so others can share

Adrienne Boswell wrote:
>
> 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!

Gazing into my crystal ball I observed "Paul Lautman"
<paul.lautman@btinternet.com> writing in news:5uf044F1hf9t2U1
@mid.individual.net:

> Adrienne Boswell wrote:
>>
>> 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!
>

Nah, it only hurts in public ... <science fiction style music>You can't
feel anything in Usenet</science fiction style music>



--
Adrienne Boswell at Home
Arbpen Web Site Design Services
http://www.cavalcade-of-coding.info
Please respond to the group so others can share