Is there a way via SQL-pass-thru to return a table from SQL Server with datetime fields as dates?

Would creating a datatype on SQL Server to limit the portion of the datetime field to just display the date be an option?

Thanks
Doug