Re: Time manipulation..

Not sure about the postgresql solution, but any of perl's CPAN date modules
should handle month/year rollovers for you correctly. Time::Piece is my
current favorite, as it's very OO; Date::Calc works well also. There's no
need to reinvent the wheel. :-)

Wes Sheldahl

"Williams, Travis L, NPONS" <tlw(at)att(dot)com>@postgresql.org on 11/12/2002
02:35:26 PM

Sent by: pgsql-general-owner(at)postgresql(dot)org

To: <pgsql-general(at)postgresql(dot)org>
cc:
Subject: [GENERAL] Time manipulation..

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly