got round the problem like this select distinct(to_days(date_file_created)), date_file_created from files
Pete M wrote:
why does this
select date(date_file_created) from files
create the error error near near '(date_file_created) from files' at line 1
trying to extract the date part of the date_tile filed
tia pete
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
