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 call future method from trigger?

917

What are sql server procedures?

958

What happens if null values are involved in string operations?

968

Explain the architecture of ms sql reporting service?

906

how you can configure a running aggregate in SSRS?

188

Explain “@@rowcount” and “@@error” in sql server?

1061

How to view existing indexes on an given table using sys.indexes?

1069

How do you debug a procedure in sql server?

925

Explain what is the purpose of sql profiler in sql server?

1053

How to enable tcp/ip protocol on a sql server?

1142

How many clustered indexes there can be on table ?

1011

Where in ms sql server is ’100’ equal to ‘0’?

1064

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1042

Explain the properties of a relational table?

1006

whats the maximum size of view state??

2177