Re: java.sql.Date returning wrong date

From:

Eric Sosman <Eric.Sosman@sun.com>

Newsgroups:

comp.lang.java.programmer

Date:

Fri, 30 Mar 2007 11:57:33 -0400

Message-ID:

<1175270254.565324@news1nwk>

Steve Austin wrote On 03/30/07 11:28,:

Hi can you assist me in finding the root cause of this problem. I am
converting a simple date of "2007-04-20" to SQL date. However for
some reason the conversion is not working. It seems to be defaulting
too 2007-01-20. Hmm.. perhaps its the getTime() not returning the
correct number of milliseconds since January 1, 1970. Not sure.
Anyway would appreciate a secound pair of eyes on this one. Thanks

import java.sql.Date;
import java.text.ParseException;
import java.text.SimpleDateFormat;

//The code

public class Testing {
   public static void main(String[] args) {

      try {
         SimpleDateFormat formater = new SimpleDateFormat("yyyy-mm-
dd");

Bzzzt! What do you imagine "mm" means to SimpleDateFormat?
To put it another way, what do you suppose you'd see if you also
displayed the time of day from the converted Date?

(Despite the identity of my employer, I cannot think of any
good reason for this bizarre behavior. It has at one time or
another tripped up everybody and his Uncle Charlie, and will keep
doing so for the forseeable future. That's "lost productivity,"
exactly the sort of thing Java was supposed to reduce. Could we
have had an easily-remembered mnemonic device like "Capital letters
for the big time units, lower-case for the small?" No, that would
make too much sense. Can *anyone* suggest a way to remember the
date format string codes short of tattooing them to the inside of
one's eyelids?)

--
Eric.Sosman@sun.com