Thread

Re: Time manipulation..

wsheldah@lexmark.com — 2002-11-12T22:10:23Z

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