This is a guess - have you tried:
SELECT * FROM tableName WHERE time = CURRENT_TIMESTAMP - '3
months'::interval
let me know if it works!
-r
At 05:49 PM 5/15/01 +0900, hiroko wrote:
hi all.
from a DB table, I'd like to SELECT out the date of 3months
before.
the command should be
=> select
hi all.
from a DB table, I'd like to SELECT out the date of 3months
before.
the command should be
=> select * from MYTBL where time =XX ;
what whould it like to be at X ?
I thought that I can use the type of 'today', which is meant
to be the 0:00am of the day.
or 'current' or thi
