aspose 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 Spring in Action this week in the Spring 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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30752
    
156

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: getting first and last date of past 6 months?