Date value showing in milliseconds

Question

When I replaced query with objectid = 1 or anything, I'm getting the result but with recvddate column of Date data type I'm the getting the error that is in above pic.

When I run the script with objectid = 1, i had seen the column value of recvddate is in milliseconds format
like

'recvddate': 1672511463000

My actual requirement is I want to filter all the records that are greater than some time value and delete those records.

Manager_HMWSSBCDC · Answer

Not in file geodatabase. I want to run this on feature layer which is published in ArcGIS Portal and accessing the data through ArcGIS API for Python.

danretired · Answer

in a file geodatabase?

SQL reference for query expressions used in ArcGIS—ArcGIS Pro | Documentation

Here is an example of a query that will return all records on or after January 1, 2011, for a date-time field from a file geodatabase data source:

INCIDENT_DATE >= timestamp '2011-01-01 00:00:00'

When a time that is not null is stored with the dates (for instance, January 12, 1999, 04:00:00), querying the date only will not return the record. When you pass only a date to a date-time field, it fills the time with zeros and retrieves only the records in which the time is 12:00:00 a.m.