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
5150 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 to use union to merge outputs from two queries together in ms sql server?

1045

explain different types of backups avaialabe in sql server? : Sql server database administration

957

How to reaname table name without using sp_Rename in sql server..?

972

How each E-R model constructs can be mapped to the relational model?

983

What are synonyms?

950

what is blocking? : Sql server database administration

1014

How to include date and time values in sql statements?

1071

How to receive output values from stored procedures?

1120

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1117

Explain partitioned view?

1052

What is change data capture (cdc) in sql server 2008?

1007

What is the default sql server instance name?

1009

What is the difference between indexing and hashing?

1142

Why and when do stored procedure recompile?

966

How to connect to SQL Azure Database by using sqlcmd?

136