troubleshooting Question

Oracle select query -> month based

Avatar of CSecurity
CSecurityFlag for Iran, Islamic Republic of asked on
Oracle Database
8 Comments2 Solutions6400 ViewsLast Modified:

I have a column which have time and date in it. assume now() function in VB.

It is like this:
2007/07/28 06:54:41

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!
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 8 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros