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

How to achieve Paging of records in SQL SERVER?

1031

Explain about the command-line tool SQLCMD?

1017

Explain the collation?

1043

What are page splits?

956

What is the primary use of the model database?

1017

How to handle error or exception in sql?

933

How to test subquery results with the exists operator?

1032

What is a covering index?

917

what is the difference between a primary key and a unique key? : Sql server database administration

945

What is full outer join in sql server joins?

981

Can we return Data from 4(more than 1) tables in stored procedure?

1004

What is the difference between dropping a database and taking a database offline?

1114

What is meant by datasource?

870

Can a function call a stored procedure in sql server?

908

what is the difference between Tabular and Matrix report?

160