insert a SYSTIMESTAMP value in postgres

From: "Leon Match" <leon(dot)match(at)convergia(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: insert a SYSTIMESTAMP value in postgres
Date: 2011-06-20 19:32:31
Message-ID: 003d01cc2f80$cbfb86c0$63f29440$@match@convergia.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)match(at)convergia(dot)net

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2011-06-20 19:47:55 Re: insert a SYSTIMESTAMP value in postgres
Previous Message Raghavendra 2011-06-20 19:27:41 Re: how to find a tablespace for the table?