select * from <Table> where datepart(month,res

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 / anilkumar manthena

3 Answers
5211 Views
I also Faced
E-Mail Answers

Answer Posted / anilkumar manthena

select * from <Table> where datepart(month,res_date)=1
It will return all the reservations made on Month "January".

Ex:
SELECT DATEPART(month, '2009-02-13 18:35:06.523')
retrieves the value 2.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we add a cpu to sql server?

1018

What language is sql server written in?

1039

What is abstracting periodical?

948

What are partitioned views?

1002

How are the unique and primary key constraints different?

1077

What are the recovery models in sql server 2000?

964

Can we shrink data file in sql server?

1053

Can an entity have two primary keys?

982

What are indexes in sql?

1286

Explain about temporary stored procedure?

1025

What is a heap?

1040

What is the cartesian product of the table?

958

What is a join in sql? What are the types of joins?

1108

What sql server means?

971

How to retrieve error messages using odbc_errormsg()?

1062