which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM
Answer Posted / sumesh
Declare @hour varchar(100)
set @time=convert(varchar,getdate(),114)
set @hour=SUBSTRING(@time,1,2)
if(convert(int,@hour)>8 and convert(int,@hour)<19)
begin
print @time
print @hour
end
Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
How to create and drop temp table in sql server?
How is a full-text index updated?
Explain nested trigger in sql?
what is sql server? : Sql server database administration
What is faster join or union?
Explain magic tables in sql server?
What is a field in a table?
what purpose does the model database serve? : Sql server database administration
Difference between group by clause and having clause in SQL?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
Which Model uses the SET concept
Tell me what is use of except clause? How it differs from not in clause?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
What is data source object?
What is the difference RDBMS and Graph Database?