DATE SEARCH IN ASPX PAGE

Posted Date: 10 Jul 2006 Posted By: Naveen Gandhi Member Level: Silver Points: 2 Responses: 1

Hello Friends
I am using SQL SERVER 2000 as a backend..
and storing the TIMEDATE field.. as a hh:mm am/pm dd/mm/yyyy
but i want to search the date ..
what could i write in the code that will match with it..
as user input is like.. 30 may 2006 or 30 may 06
and what is the parameter used in aspx page to find the date from database..
its urgent plzzzzzz
Regards
Naveen

Responses

Author: T.Thirumala Reddy 22 Oct 2008

Member Level: Bronze

Rating:

Points: 4

there is no searching idea for 06 year.
then coming to other search,
you should write like this,

select * from studenttable where year(dob)='[year number]' and left(datename (mm,dob), 3)='[monthname(it must bu 3 chars)]' and day(dob)='[daynumber]'

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : trigger problem.
	Previous : Any body tell good pl sql book reference URL and FAQ
	Return to Discussion Forum
	Post New Message
	Category: SQL Server

Related Messages

dotNet Slackers

About Us Contact Us Privacy Policy Terms Of Use