[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