Make a java.sql.Timestamp Object for a Given Year, Month, Day, Hour in Java

Description

The following code shows how to make a java.sql.Timestamp Object for a Given Year, Month, Day, Hour.

Example


  //from   www.  ja v a2  s  .c  om



import java.sql.Timestamp;
import java.util.Calendar;
import java.util.GregorianCalendar;

public class Main {
  public static void main(String[] a) {

    System.out.println(makeTimestamp(2002,02,02,02,02,02,02));
  }

  public static Timestamp makeTimestamp(int year, int month, int day, int hour, int minute,
      int second, int millisecond) {
    Calendar cal = new GregorianCalendar();
    cal.set(Calendar.YEAR, year);
    cal.set(Calendar.MONTH, month - 1);
    cal.set(Calendar.DATE, day);
    cal.set(Calendar.HOUR_OF_DAY, hour);
    cal.set(Calendar.MINUTE, minute);
    cal.set(Calendar.SECOND, second);
    cal.set(Calendar.MILLISECOND, millisecond);

    // now convert GregorianCalendar object to Timestamp object
    return new Timestamp(cal.getTimeInMillis());
  }

}

The code above generates the following result.





















Home »
  Java Tutorial »
    JDBC »




Batch
Binary Data
Database
Date Time
Insert
ResultSet
SQL
Statement
Stored Function
Table