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.match@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);