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
Answers were Sorted based on User's Feedback
Answer / sandip
//Show records for a given month
SELECT * FROM table_name (NOLOCK)
WHERE SUBSTRING(res_date, 6, 2) = (numeric value for month.
eg 01 for Jan)
//Show all the records sorted by res_date based on month.
SELECT * FROM table_name (NOLOCK)
ORDER BY SUBSTRING(res_date, 6, 2) ASC
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / 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 |
What is sql server transaction log file?
What are the steps to follow to configure SQL*Net?
What are the differences between triggers and stored procedures?
how to determine the service pack currently installed on sql server? : Sql server database administration
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
How to delete exactly duplicate records from a table?
Differentiate between a having clause and a where clause.
What are the two authentication modes in sql server?
How to swap the data of two columns in a table. both the columns containing varchar values.
Differentiate between a local and a global temporary table?
What are the steps you should follow to start sql server in single-user mode?
Do you know how to implement service broker?