从Android向MySQL发送datetime

Date currentDate = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String datetime = sdf.format(currentDate);

Connection conn = null;
PreparedStatement stmt = null;
try {
    Class.forName("com.mysql.jdbc.Driver");
    conn = DriverManager.getConnection("jdbc:mysql://your_mysql_server:port/your_database", "username", "password");
    String query = "INSERT INTO your_table (datetime_column) VALUES (?)";
    stmt = conn.prepareStatement(query);
    stmt.setString(1, datetime);
    stmt.executeUpdate();
} catch (SQLException e) {
    e.printStackTrace();
} finally {
    try {
        if (stmt != null) {
            stmt.close();
        }
        if (conn != null) {
            conn.close();
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

SELECT DATE_FORMAT(datetime_column, '%Y-%m-%d') AS formatted_date FROM your_table;