query using datetime field

[celley]

In one of my tables, I have a DateTime field. I want to write a query that will return distinct dates, regarless of the time. For example, if I had two entries in my table with the dates of:

'11/12/2001 4:23:00 PM' and
'11/12/2001 5:45:00 AM'

it would only retun one record of '11/12/2001'.

Thanks,
Chad

 

[RickCole]

Try something like:

select distinct convert(varchar(11),datecolumn) from tablename

Rick.