I hava a table say TableA,below is the data in it
the date column is MYDATE,but when i am quering this
with this query its not returning the desired result,Any idea what i am doing wrong?
Select * from TableA
Where Convert(varchar,[MYDATE], 103)) between Convert(varchar,'01/14/2004',103) and Convert(varchar,'01/15/2004',103)
MYDATE ACTION
2004-01-30 10:53:03.263 Precedent approval review required
2004-01-17 00:00:00.000 Precedent approval review required
2004-01-16 00:00:00.000 Blueprints requested from engineering
2004-01-20 00:00:00.000 Client letter of credit pending
2004-01-16 00:00:00.000 Letter of explanation approvals
2004-03-10 14:38:11.373 Need Technical Spec.
2004-03-15 09:53:29.670 Blueprints
2004-03-29 09:57:50.327 Request Blueprints
2004-04-13 13:05:44.500 2121
2004-04-15 08:47:13.873 Letter of Intent
2004-04-15 14:41:25.450 87878
2004-04-21 16:15:21.013 4578
2004-04-21 15:56:18.217 89898
2004-04-21 16:06:35.107 3434
2004-04-22 10:39:41.750 211212
2004-04-23 14:56:09.403 465465
2004-04-26 16:55:40.390 VL Test email to Brenda
2004-04-26 14:24:36.983 13232
2004-04-26 16:26:12.293 478
2004-04-26 16:06:21.843 788787
2004-04-23 11:53:27.420 Please Supplie Tech Spec
2004-04-30 10:22:37.730 complete
2004-07-26 16:14:38.903 565
2004-07-26 11:57:04.810 Test Action Item
Nouman Zaheer
Software Engineer
MSR
the date column is MYDATE,but when i am quering this
with this query its not returning the desired result,Any idea what i am doing wrong?
Select * from TableA
Where Convert(varchar,[MYDATE], 103)) between Convert(varchar,'01/14/2004',103) and Convert(varchar,'01/15/2004',103)
MYDATE ACTION
2004-01-30 10:53:03.263 Precedent approval review required
2004-01-17 00:00:00.000 Precedent approval review required
2004-01-16 00:00:00.000 Blueprints requested from engineering
2004-01-20 00:00:00.000 Client letter of credit pending
2004-01-16 00:00:00.000 Letter of explanation approvals
2004-03-10 14:38:11.373 Need Technical Spec.
2004-03-15 09:53:29.670 Blueprints
2004-03-29 09:57:50.327 Request Blueprints
2004-04-13 13:05:44.500 2121
2004-04-15 08:47:13.873 Letter of Intent
2004-04-15 14:41:25.450 87878
2004-04-21 16:15:21.013 4578
2004-04-21 15:56:18.217 89898
2004-04-21 16:06:35.107 3434
2004-04-22 10:39:41.750 211212
2004-04-23 14:56:09.403 465465
2004-04-26 16:55:40.390 VL Test email to Brenda
2004-04-26 14:24:36.983 13232
2004-04-26 16:26:12.293 478
2004-04-26 16:06:21.843 788787
2004-04-23 11:53:27.420 Please Supplie Tech Spec
2004-04-30 10:22:37.730 complete
2004-07-26 16:14:38.903 565
2004-07-26 11:57:04.810 Test Action Item
Nouman Zaheer
Software Engineer
MSR