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 |
|
Sidharthgs6
Starting Member
2 Posts |
 Posted - 2012-09-23 : 06:16:10
|
| Hai, Product Date-------------------------------------------------------- pd0 2012-08-11 18:45:55.780 Pd1 2012-08-11 18:55:17.020 pd2 2012-08-11 19:06:58.623 pd3 2012-08-18 12:00:01.193 pd4 2012-08-25 12:13:04.077 pd5 2012-08-25 17:28:30.347 pd6 2012-08-25 18:23:16.473 pd7 2012-09-18 18:29:58.360I want select the product based on from date and to date.For ExampleI want the select the product date in between 2012-08-11 to 2012-08-18 Note:dont check the time.I want the query for select product based on only date not depend upon timeSidharthan |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-09-23 : 07:52:10
|
[code]WHERE [Product Date] >= '2012-08-11'AND [Product Date] < '2012-08-19'[/code]
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Select product depend upon date