SELECT * FROM AWHERE CONVERT(NVARCHAR,TIME,112) = CONVERT(NVARCHAR,GETDATE(),112)
select * from A where time >= CONVERT(VARCHAR(10),getdate(),120)AND time < CONVERT(VARCHAR(10),DATEADD(DAY,1,getdate()),120)
