Declare @hour varchar(100) set @time=convert(varchar,getdate(),114) se

which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM

Question Posted / sumesh

5 Answers
11740 Views
Wipro, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1036

Tell me about builtinadministrator?

980

How to use subqueries in the from clause in ms sql server?

1145

What is buffer cash and log cache in sql server?

1094

what are constraints? : Sql server database administration

1033

what is denormalization and when would you go for it? : Sql server database administration

1153

How do you drop an index?

904

What is the stored procedure?

985

Explain system rowset functions?

973

What is triggers and its types?

993

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1049

What is the data tier application?

169

What is sub-query in sql server?

1185

Mention the different authentication modes in sql server.

1017

Explain alternate key, candidate key and composite key in sql server?

893