hiroko wrote:
> from a DB table, I'd like to SELECT out the date of 3months before.
> the command should be
>
> => select * from MYTBL where time =XXXXXX ;
>
> what whould it like to be at XXXXX ?
Try this:
SELECT * FROM mytbl WHERE create_date > (now() - '3 month'::interval) ;
See date/time function manual.