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@att.com>@postgresql.org on 11/12/2002
02:35:26 PM
Sent by: pgsql-general-owner@postgresql.org
To: <pgsql-general@postgresql.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@postgresql.org so that your
message can get through to the mailing list cleanly