select * from urTable Where urDateColumn Between '2007-10-20 17:00

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

Question Posted / muhammadrashidmughal

select * from urTable
Where urDateColumn
Between '2007-10-20 17:00:00 PM'
and '2007-10-21 09:00:00 AM'

Is This Answer Correct ?

14 Yes

17 No

Please Help Members By Posting Answers For Below Questions

Can we use where clause in union?

1070

What is Cross Join and in which scenario do we use Cross Join?

1015

What command must you use to include the not null constraint after a table has already been created?

1156

How to execute function in stored procedure sql server?

1160

What is the server name for sql management studio?

1030

What are the restrictions that views have to follow? : SQL Server Architecture

1007

What are the different types of data sources in ssrs?

196

What is query cost in sql server?

999

Should you normalize audio?

946

What xml support does the sql server extend?

1020

Explain primary key in sql server?

1025

List all types of constraints in sql server?

1050

Explain the working of sql privileges?

1098

Why we use functions in sql server?

1085

What is transactional replication?

973