Timespan / interval calculations?
| От | Petter Reinholdtsen | 
|---|---|
| Тема | Timespan / interval calculations? | 
| Дата | |
| Msg-id | 200011020213.KAA18168@minerva.ee.uwa.edu.au обсуждение исходный текст | 
| Список | pgsql-sql | 
I'm using PostgreSQL 6.5.  I have a table with a timestamp field.  I
want to extract all rows with a timestamp less then an hour ago.  I've
tried several things, but nothing seem to work.  How should it be
done?
I've tried 
 select * from syslog    where stamp between timestamp('now') - interval('1 hour') and 'now';
 select * from syslog    where stamp between timestamp('now') - timestamp('1 hour') and 'now';
but none of these works.
It seem to be something wrong with the interval and timespan types.
 pere=> select interval('1 hour'); ERROR:  parser: parse error at or near "(" pere=> select timespan('1 hour'); ERROR:
Function'timespan(unknown)' does not exist       Unable to identify a function which satisfies the given argument types
     You will have to retype your query using explicit typecasts pere=> 
 
Should this work, or is it my mistake?
(I'm not on the mailing list, please copy replies to me. :-)
-- 
##>  Petter Reinholdtsen  <##  |  pere@td.org.uit.no
		
	В списке pgsql-sql по дате отправления: