of course this is a php newsgroup :) try DAYOFMONTH
DAY is only available in mysql 4.1.1 "Disko_kex" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Hi SELECT RegDate FROM table WHERE month(RegDate) = '10' // this is working SELECT RegDate FROM table WHERE day(RegDate) = '2' // why isnīt this working? -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
