N/APosted on - 11/02/2012
I have free database SQLite installed and don't know how to calculate the difference of two dates.
I have a table Person with two date fields: BirthDate and DeathDate.
I need to find the difference between the dates in years.
Free database script calculate date
It's very simple question. You can this using PHP and MySQL.
Suppose you have two values
Birthday = 1-1-2000 and Dead Day = 1-1-2012
Convert both values in to milli second using this function mktime(). Visit php.net for more about this function.
After converting both values you will see dead day value will be bigger than birthdays' value. Apply subtraction method on both values. You will get difference between them. You will get value in milli second. Convert your value into simple date using PHP function and store in database or simple show to the user
If any thing is unclear you can ask me. I am here for you.