I'm not sure what this has to do with JDBC -which is what this forum is all about- but the question seems to boil down to which year is a leap year, yes? Googling for "isleapyear java source" or something like that should provide you with the code.

Ping & DNS - updated with new look and Ping home screen widget

check whether the year is leap year or not
if( leap year)
366 days
else
365 days

SCJP 1.5
"A candle looses nothing by lighting another candle"
itechmentors.com

Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 36579

16

posted

0

It is the GregorianCalendar class which has the method telling you whether it is a leap year.
It is easy enough to work out, which is what I think you are supposed to do:

Year number divides exactly by 400, OR

Year number divides exactly by 4 and doesn't divide exactly by 100.

So 1600, 1904, 1908, 2000, 2004 and 2008 were leap years, but 1900 wasn't.

Campbell Ritchie wrote:It is the GregorianCalendar class which has the method telling you whether it is a leap year.
It is easy enough to work out, which is what I think you are supposed to do:

Year number divides exactly by 400, OR

Year number divides exactly by 4 and doesn't divide exactly by 100.

So 1600, 1904, 1908, 2000, 2004 and 2008 were leap years, but 1900 wasn't.

That will work for modern years, but if you want to go back in history, it gets more complicated. 1752 only had 356 days (or maybe 354 - i'm not sure).

There are only two hard things in computer science: cache invalidation, naming things, and off-by-one errors

Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 36579

16

posted

0

It was, I think, 1585 which was 11 days short. But only in Britain; the rest of Europe had changed several years earlier! The date is in the GregorianCalendar documentation as 15th Oct 1582.