the following works: SELECT to_days( curdate() + 0 ) , to_days( curdate() + 3 ) FROM table 732033 732036
but this does not: SELECT to_days( curdate() + 0 ) , to_days( curdate() + 4 ) FROM table 732033 NULL an end of month problem or a curdate() problem or what? curdate( ) + 0, curdate( ) + 7 20040328 20040335 no month i know of has 35 days in it. 3.23.58 on red hat 7.3 Steve p.s. any tips for a query on today and today +7 days? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]