how to do calculation in SQL and save the new value?

[ivytony]

What I want to do is to add a warranty expiration date for the products my customers bought. Say the transaction date is stored in unix format. When I update each order, I'd also like to add an expiration date to the database order table.

 

I am wondering if I can do some basic calculation in SQL.

 

Say, the order date is: 1203557592 (unix time) and the expiration date will be 60 days after this: 60 * 24 * 3600 seconds.

 

thanks!

[beebum]

UNIX_TIMESTAMP(DATE_ADD(CURDATE(), INTERVAL + 60 DAY))