problem while insert date data in mysql

Hi,
I am facing folowing problem while inserting data into mysql table
mysql table is
Create table MyDate(Date Date, MyDate DateTime)

These record I have added manuly.
When I try to add record through Java it put 00 into all fields. Here is java code

import java.sql.*;
import java.util.*;
import java.text.SimpleDateFormat;
public class MyTime
{
  public static void main(String[] Args)
  {
     java.util.Date now = new java.util.Date();  
     SimpleDateFormat sdf = new SimpleDateFormat( "yyyy-mm-dd HH:mm:ss" ); 
     String sdate=sdf.format(now).toString();
     System.out.println(sdate);
     System.out.println(now);
    // Step 1: registering the MySQL JDBC driver
 
    try {     
      Class.forName("org.gjt.mm.mysql.Driver").newInstance();
    }
    catch (Exception E) {
      System.err.println("Unable to load driver.");
      E.printStackTrace();
    }
 
  // Step 2: open a connection to the "passwd" database
 
    Connection Conn = null;
    try {
      Conn = DriverManager.getConnection("jdbc:mysql://localhost/SetupDatabse");
    }
    catch (SQLException E) {
      System.err.println("SQLException: " + E.getMessage());
      System.err.println("SQLState:     " + E.getSQLState());
      System.err.println("VendorError:  " + E.getErrorCode());
    }
 
 
    // Step 3: retrieve the guest account
 
    try {

Statement Stmt = Conn.createStatement();
      
      Stmt.executeUpdate("insert into MyDate values('"+now+"','"+sdate+"')");

// Clean up after ourselves
      
      Stmt.close();
      Conn.close();
    }
    catch (SQLException E) {
      System.err.println("SQLException: " + E.getMessage());
      System.err.println("SQLState:     " + E.getSQLState());
      System.err.println("VendorError:  " + E.getErrorCode());
    }
  }
}

=====================
Now result is
C:\Padmashree\working>java MyTime
2002-40-04 18:40:37
Thu Apr 04 18:40:37 CST 2002

What is happening here?
Do i need to convert Java date type to mySql Date type ? is then how?
Any help greately appreciated.
-
padma
[ Edited by Dave to format code ]
[ April 04, 2002: Message edited by: David O'Meara ]

why don`t u insert directly current date in ur datatbase like "insert into mysql values(getdate())"
then u get tge out putlike date format ..
try this one if not understabdf mail me

sorry just now i said to sqlserver...
just put curdate()...
inserrt into mysql values(curdate(),curdate())

Hi,
I have to insert date and time data into mysql database through java prpgram.curDate() method works for mqsql but not in java program.
Realy appreciate if anyone solve this problem.
-
padma

Use prepared statements to deal with inserting/updating dates. This way you can separate the formatting from the SQL update.
Changed code:

public static void main(String[] Args)  
{
// Step 1: registering the MySQL JDBC driver     try 
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
}
catch (Exception E) 
{      
System.err.println("Unable to load driver.");
E.printStackTrace();
}
    
// Step 2: open a connection to the "passwd" database
Connection Conn = null;
 
try 
{
Conn = DriverManager.getConnection("jdbc:mysql://localhost/SetupDatabse");
}
catch (SQLException E) 
{
System.err.println("SQLException: " + E.getMessage());
System.err.println("SQLState:     " + E.getSQLState());
System.err.println("VendorError:  " + E.getErrorCode());
}
 
// Step 3: retrieve the guest account     
try 
{
PreparedStatement pStmt = Conn.prepareStatement("insert into MyDate values(?,?)");

java.util.Date now = new java.util.Date();
pStmt.setDate( 1, new java.sql.Date( now.getTime() ) );
pStmt.setTimestamp( 2, new java.sql.Timestamp( now.getTime() ) ); 
pStmt.executeUpdate();
 
// Clean up after ourselves            
Stmt.close();
Conn.close();
}    
catch (SQLException E) 
{
...
}  
}

Jamie

Hi,
Thanks.
Now My program works with PreparedStatement.
-
padma