/**
* Formats a date object for use in a mysql statement as a string.
*
* @param d - the date object to be converted
* @return Stringified date in format shown below
*/
public String formatAsMySQLDate(Date d) {
String convertedDate = null;
if (d == null || d.toString().length() == 0) {
return "";
}
if (d.toString().length() <= RsDate.MySQLDateFormat.length()) {
convertedDate = new SimpleDateFormat("yyyy-MM-dd").format(d);
} else {
convertedDate = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(d);
}
return convertedDate;
}
/**
* Converts a string from a mysql result to a date.
*
* @param s String version of the date
* @return Date object corresponding to date expressed by s
* @throws ParseException
*/
public Date convertStringToDate(String s) throws ParseException {
Date convertedDate = null;
if (s == null || s.length() == 0) return null;
try {
if (s.length() <= RsDate.MySQLDateFormat.length()) {
SimpleDateFormat formatter = new SimpleDateFormat(RsDate.MySQLDateFormat);
convertedDate = formatter.parse(s);
} else {
SimpleDateFormat formatter = new SimpleDateFormat(RsDate.MySQLDateTimeFormat);
convertedDate = formatter.parse(s);
}
} catch (ParseException e) {
}
return convertedDate;
}