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

Explain system functions or built-in functions? What are different types of system functions?

971

Where cross join is used?

954

What is a performance monitor?

972

What is difference between rownum and row_number?

963

Is foreign key unique?

990

What are the different subsets of sql?

1547

What is buffer cash and log cache in sql server?

1115

Explain a join?

1063

What is user-defined scalar function?

959

What is the use of keyword with encryption.

1026

What is the difference between cartesian product and cross join?

860

What is in place upgrade in sql server?

1036

What is @@rowcount in sql?

1002

Do you know sql server 2008 introduces automatic auditing?

976

List types of tables in SQL Azure?

126