difference between two dates
anyone help me with this...
I'm trying to get the number of day between a date and today, this must be pretty easy but I'm new in this...so will appreciate any help
Leave a comment...
- 2 Comments
Try to alter the following as per your need:
date(current) ,created, day(date(current) - created) ,
("1/1/2000" - created),
(date(current) - created)
from systables where tabid =99
Hope it helps you.
Nitin#1; Tue, 11 Dec 2007 19:17:00 GMT
- hi nitin...
well let me tell that works perfectly !!! , I really thank you...
regards...#2; Tue, 11 Dec 2007 19:18:00 GMT