convert date/time in database code

Question

Hi all, I have a combo box that is populated by a table of date/time. I have a Ms Access Database and i have OleDBadaptor with a sql statement SELECT date from date1. This populates the ComboBox with a date/time data but i would like to filter out the time. Does anyone know how to do this within the sql statement. I tried an oracle sql statement select to_char(Date, 'ddmmyyyy') from Date1 it does not work. I also used a transact sql statement select "date" = convert(char(15),date,110) from Date1 and that does not work. Is the sql that is used in C# Transact Sql or some other fragment of sql. thanks kamean