On 14.11.2013 10:50, Reimar Grabowski wrote:
For MySQL:
DATEDIFF(expr1,expr2)
DATEDIFF() returns expr1 – expr2 expressed as a value in days from one
date to the other. expr1 and expr2 are date or date-and-time
expressions. Only the date parts of the values are used in the
calculation.
:)
R.
... be carefull!
Databases as MySQL or FirebIrd or Oracle have a buildin function
DateDiff, but the result is different!!
"Our" function delivers the age of a person in years, months, days.
The other datediff function delivers years OR month OR days.
So you can't use them to calculate the age of a person for example!!
--
_______________________________________________
Lazarus mailing list
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus