How to calculate a date and a whole number

Frunkie · #1 (**permalink**) 10-17-07, 08:37

Hi all,

I have a table holding contractual data such as the date the contract was signed, the term of the contract as well as other data. I was wondering if it was possible to calculate the expiration date using the number of months that the contract is valid plus the contract start date.

If this is possible, can someone please tell me what type of query I would need to use? The two relevant fields are:

term (int)
start_date (date)

Sample data:

Code:

term     start_date
4        2007-12-03
2        2007-10-08
6        2007-03-01

The first contract would expire 2008-04-03 and so on..

What I would like to do is get the current status of the contract by using this formula. Is this possible or should I add another column for the end_date?

Thanks,

Frank

r937 · #2 (**permalink**) 10-17-07, 09:16

yes, it's possible, the type of query you want is a SELECT

Code:

select date_add(start_date, interval term month) as end_date ...

georgev · #3 (**permalink**) 10-17-07, 09:17

Frank, take a look at the Date_Add() function

Frunkie · #4 (**permalink**) 10-17-07, 09:32

Rudy, Georgie.. Thanks. That was too easy..

Is there a cheat sheet or something I can reference with regard to mysql functions? Like a quick reference? I know I can use the mysql site but sometimes it is like looking for a needle in a haystack especially if I'm not really sure what I need.

Thanks again guys!

Frank

r937 · #5 (**permalink**) 10-17-07, 10:29

Quote:

Originally Posted by fjm1967

Is there a cheat sheet or something I can reference with regard to mysql functions?

here's what i use: http://phlab.net/myman/

the mysql site search feature stinks

Frunkie · #6 (**permalink**) 10-17-07, 19:27

Thanks for the link Rudy. That was exactly what I needed.