[GENERAL] insert a SYSTIMESTAMP value in postgres

[Leon Match]

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