Format a date for inserting into a MySQL database
From CodeCodex
[edit] Implementations
[edit] Java
/**
* This method formats the provided Date class object to a format for entering into a MySQL database
*/
public static String sqlDateTime(java.util.Date date) {
java.text.SimpleDateFormat formatter;
formatter = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
return formatter.format(date);
}
[edit] Ruby
time = Time.now
mysql_date_string = time.strftime("%Y-%m-%d %H:%M:%S")
