Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
neel.mk
Starting Member
1 Post |
 Posted - 2011-01-14 : 06:10:07
|
| Hi , All i am working with a sql server 2005 database. I have table containing a field of type datetime and as well as other datatypes also.now i need to fetch value from the table filtered by the date , that i will give.but while executing the query , i am not geting any row. So, how will i do thisi am using the query asselect INTNO from Point_item_master where PointName='ABC' and Date='1/12/2010' this date will come as a parameter. please help i need it urgentlyThanksNeel |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-01-14 : 06:38:06
|
What format is the date paramater in? does it also have a time stamp?2010-01-12 03:44:00.000<> 1/12/2010 00:00:00.000 for example. If the parameter is passed on as datetime AND includes a time, that might be the problem.Does this return results?select * from Point_item_master where PointName='ABC' and Date>='1/12/2010' and Date <'1/13/2010'
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
filter table with date