How to Inserting current Date to DataBase

[prasant sahoo]

In my JSP I am sending the current date as follows

<%java.text.DateFormat dateFormat = new java.text.SimpleDateFormat("yyyy-MM-dd");
String schduleDate = dateFormat.format(new java.util.Date());
%>

<input type="text" name="scheduledDate" value="<%=dateFormat.format(new java.util.Date()) %>" readonly="true"/>

But in the DataBase (SQL) it is inserting 1/1/1900.
please help

[Bear Bibeault]

The code you have shown is merely the code that displays the date in an input box. What does it look like on the screen? The way you expect?

Without further details regarding how that date -- remember that when it submitted it will just be a String value -- is being inserted into the database, I'm not sure anyone is going to be able to help you.
[ January 16, 2008: Message edited by: Bear Bibeault ]

[Qussay Najjar]

What is the database you're using,
If it was Oracle I have a way for you..

[Paul Campbell]

DB2

current date

Oracle

sysdate

mysql

CURDATE()