Split Date and Time in sql query
You almost get it:

SELECT   TOP (10) [CUSTOMERID], 
         CONVERT(VARCHAR(20), [ENTRYTRIPDATETIME], 101) AS DATEPART,
         CONVERT(VARCHAR(20), [ENTRYTRIPDATETIME], 108) AS TIMEPART
FROM     [TP_CUSTOMERTRIPS] 
GROUP BY [CUSTOMERID],[ENTRYTRIPDATETIME] 
HAVING   COUNT(*) &gt; 2;





SELECT   TOP (10) [CUSTOMERID], 
         CONVERT(VARCHAR(20), [ENTRYTRIPDATETIME], 101) AS DATEPART,
         CONVERT(VARCHAR(20), [ENTRYTRIPDATETIME], 108) AS TIMEPART
FROM     [TP_CUSTOMERTRIPS] 
GROUP BY [CUSTOMERID],[ENTRYTRIPDATETIME] 
HAVING   COUNT(*) &gt; 2;
GO



CUSTOMERID | DATEPART   | TIMEPART
---------: | :--------- | :-------
  20063381 | 12/08/2016 | 00:24:35
  20010438 | 12/16/2016 | 22:16:55
  20013275 | 01/06/2017 | 07:42:05
  20113994 | 01/27/2017 | 01:13:44
  20018833 | 01/27/2017 | 04:53:32
  20199820 | 01/27/2017 | 05:34:24
  20015278 | 01/28/2017 | 05:18:20
  20124122 | 02/01/2017 | 02:47:01
  20108092 | 02/10/2017 | 00:37:09
  20240710 | 03/21/2017 | 13:02:18



db&lt;>fiddle here