For own documentation purposes.
private String returnDMY(Timestamp date) {
String str = "";
if (date != null) {
String d = date.toString();
// System.out.println("returnDMY (start): "+d);
int year = Integer.parseInt(d.substring(0, 4));
int month = Integer.parseInt(d.substring(5, 7));
int day = Integer.parseInt(d.substring(8, 10));
int hours = Integer.parseInt(d.substring(11, 13));
int mins = Integer.parseInt(d.substring(14, 16));
int secs = Integer.parseInt(d.substring(17, 19));
Calendar gc = new GregorianCalendar(year, month - 1, day, hours,
mins, secs);
SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
str = sdf.format(gc.getTime());
// System.out.println("returnDMY (end): "+str);
}
return str; // returns empty String if DB field is null
}
private Timestamp plusOneYear(Timestamp date)
{
//2011-03-28 00:00:00.0 - Sample timestamp
String d = date.toString();
//System.out.println("Timestamp toString():"+d);
int year = Integer.parseInt(d.substring(0, 4));
int month = Integer.parseInt(d.substring(5, 7));
int day = Integer.parseInt(d.substring(8, 10));
int hours = Integer.parseInt(d.substring(11, 13));
int mins = Integer.parseInt(d.substring(14, 16));
int secs = Integer.parseInt(d.substring(17, 19));
Calendar gc = new GregorianCalendar(year, month - 1, day, hours, mins, secs);
gc.add(Calendar.YEAR, 1);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String str = sdf.format(gc.getTime());
//System.out.println("PlusOneYear: "+str);
return Timestamp.valueOf(str);
}
