I know this is such a simple question, but I can't find the answer in the manual and I've tried very hard to find it.
I want to show all the records in a table that occurred in the last 20 min.
So, maybe something like: select * from sys_logins WHERE tstamp >= now() - '00:20';
on pg 7.3.2 this produces the error:
ERROR: Bad timestamp external representation '00:20'
Thanks for any help,
Did you mean:
select * from sys_logins
WHERE tstamp >= now()-cast('20:00' as interval);
?Regards, Tomasz Myrta
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
