SELECT and DATE Function question
От | Mike C |
---|---|
Тема | SELECT and DATE Function question |
Дата | |
Msg-id | bd0eabd0609102153h71fd59ffv6d0ca8a78c27fd9c@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: SELECT and DATE Function question
Re: SELECT and DATE Function question |
Список | pgsql-admin |
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 from blah;
The error I get is:
ERROR: operator does not exist: timestamp without time zone + integer
HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts.
But according to http://www.postgresql.org/docs/8.1/static/functions-datetime.html the + operator should support integers and treat them as days ( date '2001-09-28' + integer '7'). Obviously typing a constant into the query is a lot different from using the value of a column, but I would have thought it would work.
What is the correct way to make this calculation?
Cheers,
Mike
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 from blah;
The error I get is:
ERROR: operator does not exist: timestamp without time zone + integer
HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts.
But according to http://www.postgresql.org/docs/8.1/static/functions-datetime.html the + operator should support integers and treat them as days ( date '2001-09-28' + integer '7'). Obviously typing a constant into the query is a lot different from using the value of a column, but I would have thought it would work.
What is the correct way to make this calculation?
Cheers,
Mike
В списке pgsql-admin по дате отправления: