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 |
|
kavi12345
Starting Member
19 Posts |
 Posted - 2012-03-02 : 03:24:45
|
| hi,if we want to select the data by using DATE field,what should i do?..for example..consider a tablename as TBL1 which contains fields of customername,customercode,Date,products,Quantity..then the table have been using past 1 year(2011-2012)..so i want to select the records using DATE field..i.e...we have to select only the records using between 01-05-2011 to 01-01-2012..so for this solution,can we apply FOR condition??or anything else..please infor me guys...thans in advanc...kavichakravarthi.R |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-03-02 : 03:28:33
|
[code]SELECT *FROM TBL1WHERE [Date] between '2011-05-01' and '2012-01-01'[/code]
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
kavi12345
Starting Member
19 Posts |
Posted - 2012-03-02 : 06:47:24
|
| @Kh:Once again thank you so muchkavichakravarthi.R |
|
|
|
|
|
|
Fetching the data by using DATE field