File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes getting first and last date of past 6 months? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "getting first and last date of past 6 months?" Watch "getting first and last date of past 6 months?" New topic
Author

getting first and last date of past 6 months?

vinoth Robert
Ranch Hand

Joined: Feb 02, 2011
Posts: 31

hi,

i want to get the first date and last date of the past 6 months.
for each month the first and last date is needed.

any idea please?


vinoth.R
anirudh jagithyala
Ranch Hand

Joined: Dec 07, 2010
Posts: 41

Did you check out with Date class.....?
Date class has various methods that may serve your purpose.

Your question is not clear to me but to the extent i understand.

Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30076
    
149

Do you need to this in SQL? It's easier to use the Calendar class in Java and pass it into your query.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: getting first and last date of past 6 months?
 
Similar Threads
Blind Dates
Compatability Package for Tomcat5.5?
Comparing 2 dates
jdbc
BAckground Verification