New Members FAQ
Talk to Webmaster Tony John
DATE SEARCH IN ASPX PAGE
10 Jul 2006
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
Date: 22/Oct/2008 Rating:
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]'
This thread is locked for new responses. Please post your comments and questions as a
If required, refer to the URL of this page in your
Any body tell good pl sql book reference URL and FAQ
Return to Discussion Forum
Post New Message
Exporting SQL Server Table to Excel Using DTS
Function is not working
Asheej T K
Anil Kumar ...
Last 7 Days
Asheej T K
Awards & Gifts
Articles Rss Feeds
Forum Rss Feeds
Revenue Sharing sites
Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India
2005 - 2012 All Rights Reserved.
.NET and other trademarks mentioned in this site belong to Microsoft and other respective trademark owners.
Articles, tutorials and all other content offered here is for educational purpose only.
We are not associated with Microsoft or its partners.