Given a single user supplied date, find all of the data within 1 month of that date. In databases that support intervals and between, that'd look something like:
post_date between '2003-12-01 00:00:00' and '2003-12-01 00:00:00' + interval '1' month
What is the MaxDB equivalent to this? Note the specification of a single date is important here - I'm unable to prompt the user for the end date. I can't quite seem to find the right combination of date/time functions to make this work.
BTW - not that this is optimum, but in my trials I tried:
month(post_date) = month('2003-12-01 00:00:00' )
This generates an error "Data types must be compatible"
David
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
