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



Reply via email to