I figured out that you need to make a query layer in order to access this information from arcpy. Script looks like this:
import arcpy, os
collector_db_con = r"Database Connections\CollectorSpatialData_CollectorWriter.sde"
output = arcpy.MakeQueryLayer_management(collector_db_con, "Out", "select * from COVEYCOUNT where GDB_TO_DATE = '2019-09-30 13:56:44.4300000'")