
June 27th, 2002, 04:23 AM
|
 |
I am still learning
|
|
Join Date: Apr 2002
Location: Kuala Lumpur, Malaysia
Posts: 249
Time spent in forums: 43 m 2 sec
Reputation Power: 12
|
|
|
Select stmt question on date
I would like to select all rows from my database where my_date's day is not '01'.
This are samples what I what I want
-----------------------------------
1994-11-14
2001-01-10
This are samples what I don't want
-----------------------------------
2002-02-01
2002-01-01
1998-12-01
How can I make the query? Currently I am using 'NOT LIKE '%-01'' and I find that this query is very slow.
Any alternative on this?
Many thanks 
|