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


-- PHP Database Mailing List ( To unsubscribe, visit:

Reply via email to