dbTalk Databases Forums  

Alternative to DATEDIFF in MySQL version 4.0

Go Back dbTalk Databases Forums Databases comp.databases.mysql Alternative to DATEDIFF in MySQL version 4.0

comp.databases.mysql comp.databases.mysql


Discuss Alternative to DATEDIFF in MySQL version 4.0 in the comp.databases.mysql forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Adrienne Boswell
 
Posts: n/a

Default Alternative to DATEDIFF in MySQL version 4.0 - 01-06-2008 , 08:46 PM





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


Reply With Quote
  #2  
Old   
Peter H. Coffin
 
Posts: n/a

Default Re: Alternative to DATEDIFF in MySQL version 4.0 - 01-06-2008 , 10:10 PM





On Mon, 07 Jan 2008 01:46:35 GMT, Adrienne Boswell wrote:
Quote:
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


Reply With Quote
  #3  
Old   
Adrienne Boswell
 
Posts: n/a

Default Re: Alternative to DATEDIFF in MySQL version 4.0 - 01-07-2008 , 10:23 AM


Gazing into my crystal ball I observed "Peter H. Coffin"
<hellsop (AT) ninehells (DOT) com> writing in
news:slrnfo361n.ih0.hellsop (AT) abyss (DOT) ninehells.com:

Quote:
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.

Quote:
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



Reply With Quote
  #4  
Old   
Paul Lautman
 
Posts: n/a

Default Re: Alternative to DATEDIFF in MySQL version 4.0 - 01-07-2008 , 10:35 AM


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




Reply With Quote
  #5  
Old   
Adrienne Boswell
 
Posts: n/a

Default Re: Alternative to DATEDIFF in MySQL version 4.0 - 01-07-2008 , 10:50 AM


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

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



Reply With Quote
  #6  
Old   
Paul Lautman
 
Posts: n/a

Default Re: Alternative to DATEDIFF in MySQL version 4.0 - 01-07-2008 , 10:51 AM


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






Reply With Quote
  #7  
Old   
Adrienne Boswell
 
Posts: n/a

Default Re: Alternative to DATEDIFF in MySQL version 4.0 - 01-07-2008 , 09:50 PM


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

Quote:
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



Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top