order of adding date & interval values?
| От | Lev Lvovsky |
|---|---|
| Тема | order of adding date & interval values? |
| Дата | |
| Msg-id | Pine.BSF.4.21.0205021714390.87204-100000@renegade.pfksound.com обсуждение исходный текст |
| Ответы |
Re: order of adding date & interval values?
Re: order of adding date & interval values? |
| Список | pgsql-general |
hello,
using 7.2.1
is there any reason why the order of operations of the following query
would matter?
here's an example:
diw=# select interval '40 years' + date '2001-01-01' as test;
test
---------------------
2001-01-01 00:00:00
(1 row)
diw=# select date '2001-01-01' + interval '40 years' as test;
test
---------------------
2041-01-01 00:00:00
(1 row)
note how the first query doesn't return the proper response.
also, is there a difference between:
"interval('40 years') " and "interval '40 years' " ?
or
"date('2001-01-01')" and "date '2001-01-01' " ?
because only the query at the top of this message works, the following
doesn't:
diw=# select date('2001-01-01') + interval('40 years') as test;
ERROR: parser: parse error at or near "'"
I realize that answers my question, but why?
any help would be appreciated!!!
В списке pgsql-general по дате отправления: