Hi!
I am trying to get a list of records ina given month.
Can it be done without without using start date or enddate?
eg. select from sometable where orderdate="feb"
or
FEB=2
select from sometable where orderdate="2"
something like that
thanks
OID OrderDate TOTAL
67239 2006-01-23 4.99
238 2006-01-17 9.98
237 2006-01-13 4.99
236 2006-01-13 4.99
235 2006-01-13 4.99
234 2006-03-13 4.99
233 2006-03-13 4.99
232 2006-01-13 4.99
231 2006-01-13 4.99
230 2006-02-13 4.99
229 2006-02-13 1.99
228 2006-01-13 16.98
227 2006-01-13 4.99
226 2006-01-13 14.97
225 2006-02-13 14.97
224 2006-01-13 4.99
223 2006-01-11 1.99
222 2006-04-11 16.98
221 2006-01-11 16.98
220 2006-01-11 1.99
219 2006-01-11 1.99
218 2006-01-11 1.99
217 2006-01-11 41.96
216 2006-01-11 41.96
215 2006-01-11 4.99
214 2006-01-10 9.98
213 2006-01-10 4.99
212 2006-01-10 4.99
211 2006-01-10 4.99
210 2006-01-10 4.99
