Thread

1. Date Math

   John Goetsch <jg@seacode.com> — 2003-07-09T18:39:22Z

   Hi,
   
   I am trying to modify some timestamps in the database and cannot find
   documentation relating to date/timestamp manipulation.
   
   What I am thinking of something like:
   
   update foo set  timestamp_field  = timestamp_field + 365;
   
   where the 365 is days, or seconds or something.
   
   Any hints?
   
   Thanks
   john
   
   
   
   

2. Re: Date Math

   Jean-Luc Lachance <jllachan@nsd.ca> — 2003-07-09T18:48:18Z

   Try:
   
   update foo set  timestamp_field  = timestamp_field + '365
   days'::interval;
   
   
   John Goetsch wrote:
   > 
   > Hi,
   > 
   > I am trying to modify some timestamps in the database and cannot find
   > documentation relating to date/timestamp manipulation.
   > 
   > What I am thinking of something like:
   > 
   > update foo set  timestamp_field  = timestamp_field + 365;
   > 
   > where the 365 is days, or seconds or something.
   > 
   > Any hints?
   > 
   > Thanks
   > john
   > 
   > ---------------------------(end of broadcast)---------------------------
   > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
   
   

3. Re: Date Math

   Guy Fraser <guy@incentre.net> — 2003-07-09T22:35:13Z

   Or maybe you wanted :
   
   update foo set abstime_field = abstime_field + '1 year'::reltime;
   
   ;^)
   
   I normaly use 'abstime' and 'reltime' for dates and intervals, the major 
   difference is 'timestamp' has microsecond time accuracy, but abstime 
   takes less storage space IIRC.
   
   Guy
   
   Jean-Luc Lachance wrote:
   
   >Try:
   >
   >update foo set  timestamp_field  = timestamp_field + '365
   >days'::interval;
   >
   >
   >John Goetsch wrote:
   >  
   >
   >>Hi,
   >>
   >>I am trying to modify some timestamps in the database and cannot find
   >>documentation relating to date/timestamp manipulation.
   >>
   >>What I am thinking of something like:
   >>
   >>update foo set  timestamp_field  = timestamp_field + 365;
   >>
   >>where the 365 is days, or seconds or something.
   >>
   >>Any hints?
   >>
   >>Thanks
   >>john
   >>
   >>---------------------------(end of broadcast)---------------------------
   >>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
   >>    
   >>
   >
   >---------------------------(end of broadcast)---------------------------
   >TIP 6: Have you searched our list archives?
   >
   >               http://archives.postgresql.org
   >
   >
   >  
   >