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

What is difference between delete & truncate commands?

1090

How can you insert null values in a column while inserting the data?

1289

what are the disadvantages of cursors? : Sql server database administration

1034

what type of index will get created after executing the above statement? : Sql server database administration

978

What is store procedure?

1071

Explain partitioned view?

1095

How to return the date part only from a sql server datetime datatype?

1112

Where are full-text indexes stored?

1000

Give an example of why you would want to denormalize a database

982

What the difference between UNION and UNIONALL?

1046

List the different index configurations possible for a table?

939

What are various ways to enhance the ssrs report?

988

Explain what is public role in sql server?

1141

What is field in algebra?

1047

Can a rule be bound to any column of any data type?

965