Re: Tiiiiiiiiiiiiime

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.