compute date expiration

[jannoy]

guys how to compute for the expiration date

say in my table it has
start_date and end_date both are date format

when i approve the item the start_date will store the new date coming from server, how can i automaticallyl compute for the end_date, say expire on 3 months

eg
i approve it so the date is 2004-6-17 and expire on 2004-9-17

[tekky]

for the end date field use

DATE_ADD(start_date, INTERVAL 3 MONTHS) on your insert

examples found here...

[Sxooter]

Assuming you want transportable code, and that the database you're using understands intervals, just add it:

select datefield + interval '3 months'

That should work on 99% of all databases no problem.