Java Utililty Methods SQL Date Get

List of utility methods to do SQL Date Get

  1. HOME
  2. Java
  3. S
  4. SQL Date Get

Description

The list of methods to do SQL Date Get are organized into topic(s).

Method

StringgetDate(String pattern)
get Date 
SimpleDateFormat sf = new SimpleDateFormat(pattern);
return sf.format(new Timestamp(System.currentTimeMillis()));
java.util.DategetDate(String strDate)
Converts a String date in a "jj/mm/aaaa" format in a java.util.Date type date 
ParsePosition pos = new ParsePosition(0);
java.util.Date date = _formatter.parse(strDate, pos);
return date;
StringgetDate(String theDateStr, int days)
get Date 
Date theDate = java.sql.Date.valueOf(theDateStr);
Calendar c = new GregorianCalendar();
c.setTime(theDate);
c.add(GregorianCalendar.DATE, days);
java.sql.Date d = new java.sql.Date(c.getTime().getTime());
return d.toString();
DategetDate(String value)
Helper to create a date given a string of the form yyyy-mm-dd. 
return value != null ? getDatetime(value + " 0:0:0") : null;
java.sql.DategetDate(String year, String month, String day)
get Date 
java.sql.Date result = null;
try {
    String str = year + "-" + month + "-" + day;
    SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
    java.util.Date date1 = dateFormat.parse(str);
    result = new java.sql.Date(date1.getTime());
} catch (Exception e) {
    System.out.println("Exception " + e);
...
DategetDate(Timestamp establishdate)
Gets the date. 
if (establishdate == null)
    return new Date();
else {
    return new Date(establishdate.getTime());
DategetDate(Timestamp timestamp)
get Date 
if (timestamp != null) {
    return new Date(timestamp.getTime());
} else {
    return null;
StringgetDate(Timestamp timestamp)
Gets time in dd/mm/yy format from java.sql.Timestamp. 
GregorianCalendar cal = new GregorianCalendar();
cal.setTime(timestamp);
return getDate(cal);
StringgetDate(Timestamp ts)
get Date 
if (ts == null)
    return "";
DateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String tsStr = sdf.format(ts);
return tsStr;
DategetDateAddMonth(java.sql.Date date, int months)
get Date Add Month 
if (date == null) {
    return null;
cal.setTime(new java.util.Date(date.getTime()));
int month = cal.get(java.util.Calendar.MONTH);
cal.set(java.util.Calendar.MONTH, month + months);
return new java.sql.Date(cal.getTime().getTime());