Re: [SQL] Porting from Oracl to Postgres

2003-09-05 Thread Jeff Eckermann
--- Rod Taylor <[EMAIL PROTECTED]> wrote: > On Fri, 2003-09-05 at 00:24, Jomon Skariah wrote: > > > > Hi, > > > > Thanks for your replys. > > > > We are facing another problem now. > > > > we need to find an alternative for Oracle's > ADD_MONTHS in PostGres.. > > Guessing based on the name th

Re: [SQL] Porting from Oracl to Postgres

2003-09-05 Thread Richard Huxton
On Friday 05 September 2003 05:24, Jomon Skariah wrote: > Hi, > > Thanks for your replys. > > We are facing another problem now. > > we need to find an alternative for Oracle's ADD_MONTHS in PostGres.. SELECT now() + '1 hour'::interval; SELECT now() + '2 days'::interval; SELECT now() + '3 months':

Re: [SQL] Porting from Oracl to Postgres

2003-09-05 Thread Rod Taylor
On Fri, 2003-09-05 at 00:24, Jomon Skariah wrote: > > Hi, > > Thanks for your replys. > > We are facing another problem now. > > we need to find an alternative for Oracle's ADD_MONTHS in PostGres.. Guessing based on the name that it adds a quantity of months to a timestamp. How about an SQL I

[SQL] Porting from Oracl to Postgres

2003-09-05 Thread Jomon Skariah
Hi, Thanks for your replys. We are facing another problem now. we need to find an alternative for Oracle's ADD_MONTHS in PostGres.. Regards Jomon -Original Message- From: Rod Taylor [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 1:20 AM To: Jomon Skariah Cc: [EMAIL