Hello,
Not sure this is possible to do with SQL or if needs to be done with in the application programming language we're using(Perl), but I need to get the a weekdate, IE
SELECT EXTRACT(DAY FROM NOW())
which would return 30
Now what I need to do, is if the query above is greater or less then 15, get the next month or current month date for the 15th.
IE if I ran this query today, and the value is 30(>15), I need to generate the date 2004-09-15. If the query was run on 2004-09-14(<15) generate the date 2004-09-15, if the query was run on 2004-12-25(>15), generate the date for 2005-01-15
Is this possible to do with MySQL ??
Thx's
Mickalo
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]