Re: Timestamp plus 365 days

2004-02-13 Thread Michael Stassen
My first question would be, "Why is this column is TIMESTAMP?". It seems to me that if its purpose is to store the subscription start date, it should be of type DATE. Usually, you use a TIMESTAMP column to automatically keep track of the last updated time for a row. Either way (DATE or TIMEST

Timestamp plus 365 days

2004-02-13 Thread Matthew Stuart
Am I able to add 365 days to an already existing TIMESTAMP on a subscription service? If so I was going to use a form on a web page to update it and in the insert statement use Now() + INTERVAL 365 DAY but after some consideration, this would be wrong. This would cause a problem if a current su