posted 23 years ago
I don't know of a "standard" sql procedure, but most databases have their own way of doing this:
Oracle- use date math(sysdate - hiredate)
Access- use the dateDiff(sysdate, hiredate) function.
if the answer returns 0 then the it is the same day.
note: This will cause portablility problems between different databases. If you can live with that, check your database documentation for date functions/math.
Jamie
Jamie
[This message has been edited by Jamie Robertson (edited August 20, 2001).]