DECLARE @dt Datetime =(select '2017-11-06 10:17:00');
SELECT SUBSTRING(CONVERT(VARCHAR(10),DT,112),1,8) AS DT
FROM (SELECT @dt as DT)as ff
where '20171106101700'
like
'%'+SUBSTRING(CONVERT(VARCHAR(10),@dt,112),1,8)+'%';
SELECT DT
FROM (SELECT SUBSTRING(CONVERT(VARCHAR(10),@dt ,112),1,8) AS DT)as ff
where
SUBSTRING(DT,1,8)=SUBSTRING(CONVERT(VARCHAR(10),@dt,112),1,8)
----
DT
----
20171106
---------------------------------------------------------
SELECT ID,BIRTH_TIME,NAME,ADDRESS,PHONE,COUNTRY
FROM USERDB
WHERE
CONVERT(VARCHAR(20),BIRTH_TIME,112)
LIKE
'%'+SUBSTRING(CONVERT(VARCHAR(20),dateTimePicker,112),1,8)+'%'