Hi guys good day.
How would I eliminate the time in a datetime field.
i.e the value in the table in a datetime field is
2/9/2006 1:13:49 PM and I want to select data that has date 2/9/2006.

'assuming the xdate has (2/9/2006 1:13:49 PM) value

select * from table where xdate='2/9/2006' <---it wont work because xdate value has time and the time are included in the where clause. What I want is to select the specific date excluding the time.

thanks in advance.