Dear All,
I have 2-3 date's data entry with minues i want to count the perticuler one but get null value
| 948 |
9/23/2016 11:00:32 PM |
| 953 |
9/23/2016 11:00:52 PM |
| 958 |
9/23/2016 11:03:23 PM |
| 964 |
9/23/2016 11:03:42 PM |
| 966 |
9/23/2016 11:03:45 PM |
| 972 |
9/23/2016 11:04:04 PM |
| 979 |
9/23/2016 11:04:23 PM |
| 984 |
9/23/2016 11:04:40 PM |
| 990 |
9/23/2016 11:04:59 PM |
| 997 |
9/23/2016 11:05:18 PM |
| 1000 |
9/23/2016 11:07:11 PM |
| 1004 |
9/23/2016 11:07:22 PM |
| 1009 |
9/23/2016 11:07:41 PM |
| 1016 |
9/23/2016 11:08:00 PM |
| 1021 |
9/23/2016 11:08:17 PM |
| 1027 |
9/23/2016 11:08:36 PM |
| 1033 |
9/23/2016 11:08:55 PM |
| 1039 |
9/23/2016 11:09:12 PM |
| 1045 |
9/23/2016 11:09:31 PM |
| 1050 |
9/23/2016 11:09:50 PM |
| 1057 |
9/23/2016 11:10:07 PM |
| 1061 |
9/23/2016 11:10:26 PM |
| 1068 |
9/23/2016 11:10:45 PM |
| 1074 |
9/23/2016 11:11:02 PM |
| 1077 |
9/23/2016 11:11:21 PM |
| 1082 |
9/23/2016 11:11:40 PM |
| 1086 |
9/23/2016 11:11:57 PM |
| 1090 |
9/23/2016 11:12:16 PM |
| 1094 |
9/23/2016 11:12:35 PM |
| 1099 |
9/23/2016 11:12:52 PM |
| 1103 |
9/23/2016 11:13:11 PM |
| 1107 |
9/23/2016 11:21:08 PM |
| 1112 |
9/23/2016 11:21:27 PM |
| 1115 |
9/23/2016 11:21:30 PM |
| 1120 |
9/23/2016 11:21:49 PM |
| 1127 |
9/23/2016 11:22:08 PM |
| 1132 |
9/23/2016 11:22:25 PM |
| 1138 |
9/23/2016 11:22:44 PM |
| 1143 |
9/23/2016 11:23:03 PM |
| 1150 |
9/23/2016 11:23:20 PM |
| 1156 |
9/23/2016 11:23:40 PM |
| 1161 |
9/23/2016 11:23:59 PM |
| 1166 |
9/24/2016 6:00:49 AM |
| 1171 |
9/24/2016 6:01:08 AM |
| 1175 |
9/24/2016 6:03:35 AM |
| 1179 |
9/24/2016 6:03:54 AM |
| 1182 |
9/24/2016 6:03:57 AM |
| 1185 |
9/24/2016 6:04:16 AM |
| 1190 |
9/24/2016 6:04:36 AM |
| 1194 |
9/24/2016 6:04:53 AM |
| 1198 |
9/24/2016 6:05:12 AM |
| 1203 |
9/24/2016 6:05:31 AM |
| 1207 |
9/24/2016 6:05:48 AM |
| 1211 |
9/24/2016 6:06:07 AM |
| 1215 |
9/24/2016 6:06:26 AM |
| 1220 |
9/24/2016 6:06:43 AM |
| 1224 |
9/24/2016 6:07:02 AM |
| 1228 |
9/24/2016 6:07:21 AM |
| 1232 |
9/24/2016 6:07:38 AM |
| 1236 |
9/24/2016 6:07:57 AM |
| 1241 |
9/24/2016 6:08:17 AM |
| 1245 |
9/24/2016 6:08:34 AM |
| 1249 |
9/24/2016 6:11:17 AM |
| 1252 |
9/24/2016 6:11:36 AM |
| 1257 |
9/24/2016 6:11:55 AM |
| 1260 |
9/24/2016 6:12:01 AM |
| 1263 |
9/24/2016 6:12:20 AM |
| 1268 |
9/24/2016 6:12:39 AM |
| 1273 |
9/24/2016 6:19:19 AM |
| 1276 |
9/24/2016 6:19:38 AM |
| 1281 |
9/24/2016 6:19:57 AM |
| 1285 |
9/24/2016 6:20:14 AM |
| 1289 |
9/24/2016 6:20:33 AM |
| 1294 |
9/24/2016 6:20:52 AM |
| 1298 |
9/24/2016 6:21:09 AM |
| 1301 |
9/24/2016 6:22:12 AM |
| 1304 |
9/24/2016 6:22:31 AM |
| 1309 |
9/24/2016 6:22:50 AM |
| 1311 |
9/24/2016 6:22:57 AM |
| 1315 |
9/24/2016 6:23:16 AM |
| 1318 |
9/24/2016 7:31:34 AM |
| 1320 |
9/24/2016 8:00:48 AM |
| 1323 |
9/24/2016 8:00:59 AM |
| 1327 |
9/24/2016 8:01:18 AM |
| 1332 |
9/24/2016 8:03:38 AM |
| 1335 |
9/24/2016 8:03:57 AM |
| 1338 |
9/24/2016 8:04:00 AM |
| 1340 |
9/24/2016 8:05:35 AM |
| 1344 |
9/24/2016 8:05:55 AM |
| 1348 |
9/24/2016 8:06:09 AM |
| 1352 |
9/24/2016 8:06:28 AM |
| 1355 |
9/24/2016 8:08:06 AM |
| 1359 |
9/24/2016 8:08:25 AM |
| 1364 |
9/24/2016 8:08:44 AM |
| 1366 |
9/24/2016 8:08:50 AM |
| 1370 |
9/24/2016 8:09:09 AM |
| 1374 |
9/24/2016 8:09:23 AM |
| 1378 |
9/24/2016 8:09:43 AM |
| 1382 |
9/24/2016 8:09:57 AM |
| 1387 |
9/24/2016 8:16:20 AM |
| 1390 |
9/24/2016 8:16:39 AM |
| 1394 |
9/24/2016 8:17:03 AM |
| 1398 |
9/24/2016 8:17:22 AM |
| 1403 |
9/24/2016 8:17:41 AM |
| 1407 |
9/24/2016 8:18:00 AM |
| 1410 |
9/24/2016 8:18:09 AM |
| 1414 |
9/24/2016 8:18:28 AM |
| 1419 |
9/24/2016 8:18:47 AM |
| 1423 |
9/24/2016 8:19:06 AM |
| 1426 |
9/24/2016 8:19:15 AM |
| 1429 |
9/24/2016 8:19:34 AM |
| 1434 |
9/24/2016 8:19:53 AM |
| 1439 |
9/24/2016 8:20:12 AM |
| 1442 |
9/24/2016 8:20:21 AM |
| 1445 |
9/24/2016 8:20:40 AM |
| 1449 |
9/24/2016 8:30:48 AM |
| 1454 |
9/24/2016 8:31:07 AM |
| 1464 |
9/24/2016 8:33:35 AM |
| 1469 |
9/24/2016 8:33:54 AM |
| 1476 |
9/24/2016 8:34:13 AM |
| 1481 |
9/24/2016 8:34:32 AM |
| 1487 |
9/24/2016 8:34:51 AM |
| 1489 |
9/24/2016 8:34:52 AM |
| 1495 |
9/24/2016 8:35:11 AM |
| 1500 |
9/24/2016 8:35:31 AM |
| 1507 |
9/24/2016 8:35:50 AM |
| 1513 |
9/24/2016 8:36:09 AM |
| 1518 |
9/24/2016 8:36:19 AM |
| 1522 |
9/24/2016 8:36:38 AM |
| 1529 |
9/24/2016 8:36:57 AM |
| 1535 |
9/24/2016 8:37:16 AM |
| 1540 |
9/24/2016 8:37:36 AM |
| 1545 |
9/24/2016 8:37:46 AM |
| 1551 |
9/24/2016 8:38:05 AM |
| 1557 |
9/24/2016 8:40:06 AM |
| 1563 |
9/24/2016 8:40:25 AM |
| 1571 |
9/24/2016 8:40:48 AM |
| 1577 |
9/24/2016 8:41:07 AM |
| 1582 |
9/24/2016 8:41:26 AM |
| 1589 |
9/24/2016 8:49:27 AM |
SELECT ID,DATETIME
FROM TABLE
WHERE (DATETIME = '9/24/2016')
