SQL-only find time and not date in Access Date/Time field -

Some date / time data is corrupted in an Access database table and now only shows one time eg 15:15. Is there any SQL that allows me to select a record which is the only time data and not in any date data?

I have tried to do this, but it does not work

  from table WHERE ISDate (datetimefield) = 0  

choose datetimefield>

is not different in access date and time columns ( Field) type, therefore these "things" and "time"

1. the date / time value where the time will be exactly midnight default will appear as a date only.

2. The date / time value where the part of the date will be 1899-12-30 by default will only be displayed as a time.

Code> format () can be displayed using function).

Then, the seek-by date / time values ​​that look like are the only time you do

  SELECT datetimevalue FROM tablename WHERE datetimevalue & gt; = # 1899-12-30 # and datetimevalue & lt; # 1899-12-31 #