Free database script calculate date

Asked By jabez zion 10 points N/A Posted 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.

 

• Status: Open
• Question Views: 950
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By fun.maaza 0 points N/A #132644

Free database script calculate date

Hello dear,

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.

About fun.maaza

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 11/02/2012
• Question Category: MS SQL Server