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
5442 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

Mention the differences between having and where clause.

1119

What is isolation levels?

1082

Why is normalisation important?

989

What is query cost in sql server?

1037

What is difference between drop truncate and delete?

1149

What are sp_configure commands and set commands?

1072

What is Command line parameters in PLSQL.?

1183

What are drilldown reports?

160

How to Sync Two SQL Azure Databases?

121

What are the properties of the transaction?

1051

What type of Index will get created after executing the above statement?

1142

What is a transact-sql statement?

1128

How to modify an existing user defined function?

1169

What are types of scd? : sql server analysis services, ssas

1077

What is efficiency data?

1002