Oracle select query -> month based
Posted on 2007-07-28
I have a column which have time and date in it. assume now() function in VB.
It is like this:
It have about 10000 records with a column called last which have date and time in format I wrote above.
Now I want to select data from oracle which is in a range.
In real words for example I want to select data which is for October or January or May... I want to select from Oracle month based. How it is possible with date and time I have in my table?
I need exact query.
Thanks from now!