On Mon, 20 Jun 2011 15:32:31 -0400, Leon Match wrote:
> Hello, > > I am trying to re-create few objects from oracle into postgres. > > I have a problem inserting a timestamp value into the table: > > insert into request_queue (request_id, received_time > > ) > > values (new.request_id, SYSTIMESTAMP > > ); > > How can I insert a dynamic timestamp value in postgress, please? > > Thank you, > > Leon > > leon.ma...@convergia.net May be: insert into request_queue (request_id, received_time) values (new.request_id, (abstime(('now'::text)::timestamp(6) with time zone))::integer); -- Regards, Condor