Gregorian Calender Year

You need to use a DateFormat with yyyy

example?

http://javaalmanac.com/egs/java.text/FormatDate.html

Let me rephrase my question.. i wish to compare a date in gregorian format
to a date in my db which is in varchar format.

how do i do this

(points up to 400)

using select sql

Please show how your varchar dates look

30/1/6

30th jan 2006

DateFormat df = new SimpleDateFormat("MM/d/y");
java.util.Date fromDb = df.parse(resultSet.getString("DateCol"));
boolean dbLater = fromDb.after(otherDate);

following shows you how to parse a date

http://javaalmanac.com/egs/java.text/ParseDate.html?l=rel

you could also use a PreparedStatement and do the comparison directly in the query
that would save you havin g to bother with parsing altogether

How do i compare if a gregoraion date is equal to another greg date?

How do i convert a greg date to the above MM/D/Y

boolean equalDates = date1.equals(date2);

:-)