This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes JDBC and the fly likes Date Extraction Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Date Extraction" Watch "Date Extraction" New topic

Date Extraction

Aditi agarwal
Ranch Hand

Joined: Feb 23, 2011
Posts: 225
hey i have a table in which i have a field with date & time but its data type is date

now i want to comapre my this field on basis of month & year entered by me

Now i want to know how can i extract month & year only from my this field in database

Please help me

thank you
Swastik Dey

Joined: Jan 08, 2009
Posts: 1477

Does this help?

Rob Spoor

Joined: Oct 27, 2005
Posts: 19723

Which of course won't work in several other servers like MS SQL Server. That one has functions YEAR, MONTH, DAY and DATEPART. So without knowing the database server in question we cannot answer this question (unless we provide the answer for each and every database server available).

How To Ask Questions How To Answer Questions
jQuery in Action, 2nd edition
subject: Date Extraction