Using Arc Desktop 10.3.1 I have a datetime field that is in the format of MM/DD/YY HH:MM:SS Some of the records have a only a date and some have both a time and a date. I want to strip off the time part using .split(" ") but I am having difficulty figuring out how to craft the query to only select the records that have a time part. I have tried:
select * from !DateTime!.split(" ") > 0
The logic being I want to select all records from DateTime where the trailing time is greater than 0, then after they are selected I will run the field calculator to strip the time.