DateDiff

Hi all.

I have to write an app that interacts with mySQL (I really must have done
some evil, evil stuff in a previous life to be landed with this!)

I need to work out the difference in days between values in the database and
the current date. "No problem," thought I , "I'll just use the SQL DATEDIFF
command." Heh! Well, the user interface I'm using didn't even recognise
DATEDIFF as being a function, so I decided to visit the mySQL website.

Their description of DATEDIFF is as follows:

------------------------
DATEDIFF(ARGUMENTS)
TIMEDIFF(ARGUMENTS)
[Rest of description to be added here]

NEED EXAMPLE
DATEDIFF() and TIMEDIFF() were added in MySQL 4.1.1.
------------------------

Wow! How helpful! I can't believe that they don't provided decent
documentation for their database server!

I had a quick Google, but couldn't find ANY pages describing how to use it,
only pages complaining about its non-existence in previous versions.

Can anyone help me here?

--
Lofty
http://www.brainache.demon.co.uk

- There are 10 types of people in this world:
Those who understand binary, and those who don't.

Since date values are just doubles in disguise, you can do simple arithmetic
on them. The difference in days is just Date2 - Date1, plus one if the count
is inclusive. If the dates include time values (the decimal part) you'll
need to convert to integer first.


"Lofty" wrote in message

 > Hi all.
 >
 > I have to write an app that interacts with mySQL (I really must have done
 > some evil, evil stuff in a previous life to be landed with this!)
 >
 > I need to work out the difference in days between values in the database
and
 > the current date. "No problem," thought I , "I'll just use the SQL
DATEDIFF
 > command." Heh! Well, the user interface I'm using didn't even recognise
 > DATEDIFF as being a function, so I decided to visit the mySQL website.
 >
 > Their description of DATEDIFF is as follows:
 >
 > ------------------------
 > DATEDIFF(ARGUMENTS)
 > TIMEDIFF(ARGUMENTS)
 > [Rest of description to be added here]
 >
 > NEED EXAMPLE
 > DATEDIFF() and TIMEDIFF() were added in MySQL 4.1.1.
 > ------------------------
 >
 > Wow! How helpful! I can't believe that they don't provided decent
 > documentation for their database server!
 >
 > I had a quick Google, but couldn't find ANY pages describing how to use
it,
 > only pages complaining about its non-existence in previous versions.
 >
 > Can anyone help me here?
 >
 > --
 > Lofty
<font color=purple> > <a rel="nofollow" style='text-decoration: none;' href="http://www.brainache.demon.co.uk</font" target="_blank">http://www.brainache.demon.co.uk</font</a>>
 >
 > - There are 10 types of people in this world:
 > Those who understand binary, and those who don't.
 >
 >
 >
 >