Re: [ADMIN] SELECT and DATE Function question

2006-09-10 Thread Mike C
That works great, thank you!MikeOn 9/11/06, Aaron Bono <[EMAIL PROTECTED]> wrote: On 9/10/06, Mike C <[EMAIL PROTECTED] > wrote: Hi,I'm trying to calculate an expiration date by adding the number of days onto the start date. i.e. select start_date + number_of_days from blah; create table blah (sta

Re: [ADMIN] SELECT and DATE Function question

2006-09-10 Thread Aaron Bono
On 9/10/06, Mike C <[EMAIL PROTECTED]> wrote: Hi,I'm trying to calculate an expiration date by adding the number of days onto the start date. i.e. select start_date + number_of_days from blah; create table blah (start_date timestamp, number_of_days integer); insert into blah values (current_timesta

[ADMIN] SELECT and DATE Function question

2006-09-10 Thread Mike C
Hi,I'm trying to calculate an expiration date by adding the number of days onto the start date. i.e. select start_date + number_of_days from blah; create table blah (start_date timestamp, number_of_days integer); insert into blah values (current_timestamp, 25);select start_date + number_of_days fro