of course this is a php newsgroup :) try DAYOFMONTH DAY is only available in mysql 4.1.1 "Disko_kex" <disko_kex@swedish-mushroom.com> wrote in message 001201c380e6$1d6caa40$e900a8c0@lokalguirdcfee">news:001201c380e6$1d6caa40$e900a8c0@lokalguirdcfee... 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
