[ciapug] calendars
Scott Phillips
ciapug@cialug.org
Thu, 05 May 2005 14:19:12 -0500
Good points. I'm going to complicate matters slightly.
I'd like the date to be required but start/end times optional. How should
I keep track of whether this is an all-day event (no specific time) or
meeting with time specified. Perhaps an all-day-flag field?
Trivial questions? Probably. But I like to hear how others approach
things and this list has been real quiet lately!
At 01:42 PM 5/5/2005 -0500, you wrote:
><snip>
>I would say start & duration, since you can always calculate end time from
>the other 2 and it's easier to do offsets than diffs between times.
></snip>
>
>Depends on how you store you date/time fields. I think using native DBMS
>date/time data types are worthless and, instead, we opt to use unix
>timestamps, when possible (since the timestamp can't work well before 1970
>or whatever it is)
>
>--Tony
>_______________________________________________
>ciapug mailing list
>ciapug@cialug.org
>http://cialug.org/mailman/listinfo/ciapug