how to use subquery in Like operaror SQL SERVER

Try this query

declare 
	@date varchar(10);
select 
	@date = convert(varchar(10), getdate(),126);
select 
	convert(varchar(20),[date] , 120) from timesheetentry 
where 
	[date]>= @date+' 00:00:00.000' and [date]< @date+' 23:59:59:998'

Above solutions work properly, but I think comparing date values as string (varchar) is not a good idea as it will limit to check just one value(date) and cannot use between and other operators.

According to your question you need to compare just the date part of the datetime value not the time part so the Query will be :

select CONVERT(VARCHAR(20),[date] , 120) from timesheetentry
where Convert(DateTime,Convert(Char(10),[date],120),120) = Convert(DateTime,Convert(Char(10),getdate(),120),120) 

this way the time part will be excluded from the Datetime value and Datetime operators(between) can also be used for comparisons.

select * from news_master where date like (select top(1) date from news_master)

i have tried this one and work for me may be you also

subquery should return single Value and the like will return more than one records therefore directly you can not use like in subquery but you can use top(1)

Try this code.

declare @v varchar(1000)
set @v='select CONVERT(VARCHAR(20),[date] , 120) from timesheetentry
where [date] LIKE  '
Set @v = @v + ''''+ convert(varchar(10), getdate(), 126)+'%'''

exec(@v)