Re: [GENERAL] insert a SYSTIMESTAMP value in postgres

2011-06-21 Thread Leon Match
Kussama [mailto:osvaldo.kuss...@gmail.com] Sent: Monday, June 20, 2011 3:45 PM To: Leon Match Subject: Re: [GENERAL] insert a SYSTIMESTAMP value in postgres 2011/6/20 Leon Match : > Hello, > > I am trying to re-create few objects  from oracle into postgres. > > I have a prob

Re: [GENERAL] insert a SYSTIMESTAMP value in postgres

2011-06-20 Thread Jaime Casanova
El 20/06/2011 14:33, "Leon Match" escribió: > > 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 > >

Re: [GENERAL] insert a SYSTIMESTAMP value in postgres

2011-06-20 Thread Condor
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_

Re: [GENERAL] insert a SYSTIMESTAMP value in postgres

2011-06-20 Thread David Johnston
Please look at the section on Date/Time Functions in the PostgreSQL documentation (Section 9.9 in Version 9.0 documentation) for a full listing of the date and time functions available in PostgreSQL and how they work. There is a sub-section (9.9.4) that specifically details functions that return th

Re: [GENERAL] insert a SYSTIMESTAMP value in postgres

2011-06-20 Thread Scott Ribe
On Jun 20, 2011, at 1:32 PM, Leon Match wrote: > How can I insert a dynamic timestamp value in postgress, please? < http://www.postgresql.org/docs/9.0/static/functions-datetime.html> -- Scott Ribe scott_r...@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via p