On Tue, 17 Jan 2006, John Peacock wrote:
My questions are:
1) What should I store in the database?
a) Native MySQL DATETIME field?
I'd go with this one, since it will make it easiest to do many operations
in the DBMS (sorting, restriction queries by date, etc).
2) Should I use DateTime at all, since primarily I am interested in events
scheduled for a specific date (time is not necessarily important)? The most
common "operation" on a date for this purpose is "how many weeks until event
X" so I can display the next week's events or send out scheduling e-mails
prior to events.
Again, if you use MySQL's native DATETIME or DATE type, you can do all
this in the DBMS quite easily, which is nice.
If you need to translate Hebrew dates into Gregorian dates, which I assume
you do, then I'd think DateTime would help with that.
-dave
/*===================================================
VegGuide.Org www.BookIRead.com
Your guide to all that's veg. My book blog
===================================================*/
