Depends on database, but let's say for MySql
you could do
Select * from table where month(datefield) = 3
and you would get only the March dates
On Jan 18, 2010, at 1:35 PM, Roland Dumas wrote:
Given: table with event records. One column is a date field.
Question: how do I request a date and get back only records in the
same calendar month as the requested date?
Ex: I put in 05/06/2010 and get back a set of records that are all
05/XX/2010
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Ben Johansen
http://www.webspinr.com
[email protected]
Phone: 360-597-3372
Mobile: 360-600-7775
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
