| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | "Williams, Travis L, " NPONS <tlw(at)att(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Time manipulation.. |
| Date: | 2002-11-12 20:44:35 |
| Message-ID: | 1037133875.27219.53.camel@camel |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 2002-11-12 at 14:35, Williams, Travis L, NPONS wrote:
> If I have a date/time column using timestamp.. how can I manipulate the date/time easily.. like take the date/time and add 7 days to it and get the correct date.. or subtract 5 days.. or anything like that.. I can do it all in perl (which I have done in the past).. but I hate dealing with month/year roll overs..
>
> Travis
>
Well, you can easily do things like select now() + '7 days'::interval;
or select now() - '5 days'::interval; and if you need just a part of
the time use the date_part() function. check the docs for more info and
other suggestions.
Robert Treat
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Medi Montaseri | 2002-11-12 21:33:15 | Re: Time manipulation.. |
| Previous Message | scott.marlowe | 2002-11-12 20:26:34 | Re: Upgrade to dual processor machine? |