[Lazarus] DateDif function needed

Reimar Grabowski reimgrab at web.de
Thu Nov 14 10:50:18 CET 2013


On Wed, 13 Nov 2013 20:34:36 +0100
John Landmesser <JohnML at online.de> wrote:

> What about Databases like mysql, Oracle, Firebird. I'm shure they have 
> such a function.

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.




More information about the Lazarus mailing list