Charlie Griefer wrote: > oooh...that's cleaner than mine :) Maybe, some databases have the gall not to have Month() and Day() functions... postgres has neither... mysql didn't have Day() until 4.1.something.. although they had DayOfWeek().
Plus, if you want to use indexes, you can't do it the way I suggested (well, in oracle you can have function-based indexes). - Rick > > > On Thu, 17 Feb 2005 11:26:52 -0500, Rick Root <[EMAIL PROTECTED]> wrote: > >>Mickael wrote: >> >>>select * from table where date between Jan2005 and feb2005 ( so in essence >>>not having to say Jan 1, 2005 and Feb 28, 2005) >> >>How about: >> >>WHERE >> MONTH(date) >= 1 and >> YEAR(date) >= 2005) and >> MONTH(date) <= 2 and >> YEAR(date) <= 2005 >> >> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195198 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
