date/time problem in v6.5.3 and 7.0.0 ...
От | The Hermit Hacker |
---|---|
Тема | date/time problem in v6.5.3 and 7.0.0 ... |
Дата | |
Msg-id | Pine.BSF.4.21.0001142201470.46499-100000@thelab.hub.org обсуждение исходный текст |
Ответы |
Re: [HACKERS] date/time problem in v6.5.3 and 7.0.0 ...
|
Список | pgsql-hackers |
I can add days to now(), but not subtract? ===================================== template1=> select now() + '30 days'; ?column? ------------------------------Sun Feb 13 22:00:33 2000 AST (1 row) template1=> select now() - '30 days'; ERROR: Unable to identify an operator '-' for types 'timestamp' and 'unknown' You will have to retype this query usingan explicit cast template1=> select version(); version ---------------------------------------------------------------------PostgreSQL 7.0.0 on i386-unknown-freebsd4.0, compiledby gcc 2.95.2 (1 row) Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
В списке pgsql-hackers по дате отправления: