Thread

1. Trouble with dates

   Bassel Hatoum <bassel@gnc.net> — 1998-05-30T22:28:37Z

   I'm trying to add months to a date without having to calculate how many
   days in the month, etc.
   Oracle has an add_month function that would do the trick.  It there
   anything similar in PGSQL?  Or maybe a way to emulate it?
   
   Thanks in advance.
   
   Bassel Hatoum
   
   
   

2. Re: [SQL] Trouble with dates

   Marin D <marin@cybernet.bg> — 1998-05-31T16:56:13Z

   CREATE TABLE test (d DATE);
   
   INSERT INTO test VALUES (CURRENT_DATE);
   
   
   test=> SELECT DATE( DATETIME(d) + '1 month'::TIMESPAN) FROM test;
   
         date
   ----------
   30-06-1998
   (1 row)
   
   test=>
   
   
   Hope this helps...
   
   	Marin
   
             -= Why do we need gates in a world without fences? =-
   
   
   On Sat, 30 May 1998, Bassel Hatoum wrote:
   
   > I'm trying to add months to a date without having to calculate how many
   > days in the month, etc.
   > Oracle has an add_month function that would do the trick.  It there
   > anything similar in PGSQL?  Or maybe a way to emulate it?
   > 
   >