how to convert as "2012-05-03" date format only

[raj.mscking@gmail.com]

Nice To meet all

i need a date format of "yyyy-mm-dd", only,
To get current date from the system, and store in MySQL data base.

i try with "import java.util.Calendar;"

SimpleDateFormat formatter = new SimpleDateFormat("dd/MM/yyyy");

Date today = new Date();

Date todayWithZeroTime =formatter.parse(formatter.format(today));

but it show me the format of "Fri May 04 12:57:55 IST 2012" only,

can Anyone guide me..,
Thank you for your help..,

[brynpttrsn]

formatter.parse() takes text and puts it back into the default date format.

formatter.format() formats the date according to its specifications.

formatter.parse(formatter.format()) will take the formatted date and convert it right back to the default format.

You don't want to parse a formatted date.

[Tolls]

A Date object does not have a format.
It is simply a long representing the number of milliseconds since the epoch (1/1/1970 UTC).
How is your date column represented in the database?
If it's as a DATE then there is no need to do anything other than turn the util.Date into a sql.Date.

[raj.mscking@gmail.com]

Thank you for your response sir!
which one shall i fallow,

formatter.format()
or
formatter.parse(formatter.format())

replay please..,

[brynpttrsn]

Ahh yes. I probably didn't word my explanation very well.
format() returns a String, not a Date
As for Sql.... you can take over from here because I'm useless.

Edit:
format(date) returns your formatted date as a string
parse(formattedDate) returns a Date

[raj.mscking@gmail.com]

ok, Thank you..,

[Tolls]

It might be an idea to answer my question above, because if this is going into a DATE column in MySQL there is no need to remove the time element, as setDate() will only take the date portion into the database anyway.

[raj.mscking@gmail.com]

i wants to create log in form for Client
if the Client log in with that form it will be forward to my serversocket (username, password with current time)
and i have to insert the LOG IN table with (username, password with current time and current date of server)

when log out the user i have receive the (username, password with current time)
then i update the LOG IN table with (current time) where (username and current date of server)

to avoid the repeating of same user on that same day , i wants to check with date..,

if i use the date as it is , it will never check with (where), because date will add with time stamp..,
That's all sir!..,

[Tolls]

You still haven't answered the question.
What MySQL datatype is the current_date column?

[raj.mscking@gmail.com]

sir! The Data Type is,
The DATE type is used for values with a date part but no time part. MySQL retrieves and displays DATE values in 'YYYY-MM-DD' format sir..,

[raj.mscking@gmail.com]

I got the answer sir!
To get the current date in MySQL have to place the method of " CURDATE()"..,
i replace it in java,

I lot of Thanks to you all my Brethren's,
i am very happy now..,

[Tolls]

So, since it was a DATE there was no need to convert anyway.
You could simply have done:

java.sql.Date today = new Date();
<yourPreparedStatement>.setDate(today);

No conversion needed at all.

Of course, using MySQLs own built in functionality is preferable.

[raj.mscking@gmail.com]

Yes!
as your idea it is working well,
i am lucky, Today i learn new idea because of you sir,
thank you very much sir..,