select * from tablename where res_date>'2010-01-01 00:00:00.000&#

create table with fields ID, reserved_by,res_date
res_date is datefield like 2010-03-09 00:00:00.000 from
2005 to 2006 any date assume
based on res_date need to slect table and display
based on month (full jan details in database irrespective
of date and year

Question Posted / thangas sujith prabu.s

3 Answers
5456 Views
I also Faced
E-Mail Answers

Answer Posted / thangas sujith prabu.s

select * from tablename where res_date>'2010-01-01
00:00:00.000' and res_date<'2010-02-01 00:00:00.000'

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can you control the amount of free space in your index pages?

1103

What is instead of trigger sql server?

1081

What is the difference between left and right outer join?

1115

How to update multiple rows with one update statement in ms sql server?

1263

What is the difference between seek predicate and predicate?

1111

What are the advantages of using stored procedures in sql server?

1056

Does a server store data?

956

What is rs.exe utility?

164

What is data file in computer?

1002

How to deploy the Report?

140

Tell me what is normalization? Explain different forms of normalization?

1075

Does group by or order by come first?

1001

Explain the difference between HTTP and HTTPS in database?

1098

What is the purpose of update statistics and scope_identity() function?

1160

Explain what are the events recorded in a transaction log?

1053