Received: from mail3.mx.voyager.net (mail3.mx.voyager.net [216.93.66.202]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6BGdla55477 for ; Wed, 11 Jul 2001 12:39:47 -0400 (EDT) (envelope-from mvincent@cablespeed.com) Received: from Mitch (205user40.ctstelecom.com [216.120.205.40] (may be forged)) by mail3.mx.voyager.net (8.10.2/8.10.2) with SMTP id f6BGdgN72053; Wed, 11 Jul 2001 12:39:43 -0400 (EDT) Message-ID: <000d01c10a28$13ac67c0$1a0d040a@Mitch> From: "Mitch Vincent" To: "Chris Ruprecht" , "p-php" References: <002101c10a12$bea29660$5dd26383@corp.compucom.com> Subject: Re: Date Manipulations Date: Wed, 11 Jul 2001 12:39:32 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200107/12 X-Sequence-Number: 469 Well, it depends on what you're trying to do :-) You can add days an arbitrary date in a number of ways , I often let PG handle it though (as you are).. I generally do something like SELECT ('05-05-2001'::date + '5 days'::interval) Or something like that if I need X days ahead or behind date Y... ----- Original Message ----- From: "Chris Ruprecht" To: "p-php" Sent: Wednesday, July 11, 2001 10:06 AM Subject: [PHP] Date Manipulations > Hi all, > > Currently, when working with dates, I use constructs like > > ('$NewDate'::date + 5)::date > > this seems a little clumsy to me and I was wondering if there was an easier > way of doing this. > > Best regards, > Chris > > > > _________________________________________________________ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >