[ic] How to work with dates/timestamps?

Zachary Matthews zac@mediapc.com
Mon, 06 Nov 2000 17:49:32 -0800


I am using interchange to set up an events calendar.  I will create a 
table called events, with a field for date.

I want to create a page that will display all events within a six month
date range (3 months past, and 3 months into the future).

Does anyone have any recommendations on what format I should use for the
date field within the events table.  I assume interchange has some handy
routines for dealing with dates (can someone point me to these).  Should
I use the standard PERL time format (seconds since Jan 1, 1970), or some
other format.  Is there a tag that takes a timestamp number and converts
it to a formatted date and vice-versa?

Basically I want to use the admin section to enter a new event with a
date.  Then I want a page that will search for events that fall within a
date range.

Thanks for the help,
Zac