This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 32481
    
214

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


[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: getting first and last date of past 6 months?
 
It's not a secret anymore!