How to use

toString

method

in

org.postgresql.jdbc2.TimestampUtils

public void setTime(int i, Time t, java.util.Calendar cal) throws SQLException
{
  checkClosed();
  if (t == null)
  {
    setNull(i, Types.TIME);
    return;
  }
  if (cal != null)
    cal = (Calendar)cal.clone();
  bindString(i, connection.getTimestampUtils().toString(cal, t), Oid.UNSPECIFIED);
}

public void setDate(int i, java.sql.Date d, java.util.Calendar cal) throws SQLException
{
  checkClosed();
  if (d == null)
  {
    setNull(i, Types.DATE);
    return;
  }
  
  if (cal != null)
    cal = (Calendar)cal.clone();
  // We must use UNSPECIFIED here, or inserting a Date-with-timezone into a
  // timestamptz field does an unexpected rotation by the server's TimeZone:
  //
  // We want to interpret 2005/01/01 with calendar +0100 as
  // "local midnight in +0100", but if we go via date it interprets it
  // as local midnight in the server's timezone:
  // template1=# select '2005-01-01+0100'::timestamptz;
  //       timestamptz       
  // ------------------------
  //  2005-01-01 02:00:00+03
  // (1 row)
  // template1=# select '2005-01-01+0100'::date::timestamptz;
  //       timestamptz       
  // ------------------------
  //  2005-01-01 00:00:00+03
  // (1 row)
  bindString(i, connection.getTimestampUtils().toString(cal, d), Oid.UNSPECIFIED);
}

  connection.encodeString(connection.getTimestampUtils().toString(null, (Date)valueObject));
break;
  connection.encodeString(connection.getTimestampUtils().toString(null, (Time)valueObject));
break;
  connection.encodeString(connection.getTimestampUtils().toString(null, (Timestamp)valueObject));
break;

bindString(i, connection.getTimestampUtils().toString(cal, t), Oid.UNSPECIFIED); // Let the server infer the right type.

public void setTime(int i, Time t, java.util.Calendar cal) throws SQLException
{
  checkClosed();
  if (t == null)
  {
    setNull(i, Types.TIME);
    return;
  }
  if (cal != null)
    cal = (Calendar)cal.clone();
  bindString(i, connection.getTimestampUtils().toString(cal, t), Oid.UNSPECIFIED);
}

public void setTime(int i, Time t, java.util.Calendar cal) throws SQLException
{
  checkClosed();
  if (t == null)
  {
    setNull(i, Types.TIME);
    return;
  }
  if (cal != null)
    cal = (Calendar)cal.clone();
  bindString(i, connection.getTimestampUtils().toString(cal, t), Oid.UNSPECIFIED);
}

public void setDate(int i, java.sql.Date d, java.util.Calendar cal) throws SQLException
{
  checkClosed();
  if (d == null)
  {
    setNull(i, Types.DATE);
    return;
  }
  
  if (cal != null)
    cal = (Calendar)cal.clone();
  // We must use UNSPECIFIED here, or inserting a Date-with-timezone into a
  // timestamptz field does an unexpected rotation by the server's TimeZone:
  //
  // We want to interpret 2005/01/01 with calendar +0100 as
  // "local midnight in +0100", but if we go via date it interprets it
  // as local midnight in the server's timezone:
  // template1=# select '2005-01-01+0100'::timestamptz;
  //       timestamptz       
  // ------------------------
  //  2005-01-01 02:00:00+03
  // (1 row)
  // template1=# select '2005-01-01+0100'::date::timestamptz;
  //       timestamptz       
  // ------------------------
  //  2005-01-01 00:00:00+03
  // (1 row)
  bindString(i, connection.getTimestampUtils().toString(cal, d), Oid.UNSPECIFIED);
}

public void setDate(int i, java.sql.Date d, java.util.Calendar cal) throws SQLException
{
  checkClosed();
  if (d == null)
  {
    setNull(i, Types.DATE);
    return;
  }
  
  if (cal != null)
    cal = (Calendar)cal.clone();
  // We must use UNSPECIFIED here, or inserting a Date-with-timezone into a
  // timestamptz field does an unexpected rotation by the server's TimeZone:
  //
  // We want to interpret 2005/01/01 with calendar +0100 as
  // "local midnight in +0100", but if we go via date it interprets it
  // as local midnight in the server's timezone:
  // template1=# select '2005-01-01+0100'::timestamptz;
  //       timestamptz       
  // ------------------------
  //  2005-01-01 02:00:00+03
  // (1 row)
  // template1=# select '2005-01-01+0100'::date::timestamptz;
  //       timestamptz       
  // ------------------------
  //  2005-01-01 00:00:00+03
  // (1 row)
  bindString(i, connection.getTimestampUtils().toString(cal, d), Oid.UNSPECIFIED);
}

  connection.encodeString(connection.getTimestampUtils().toString(null, (Date)valueObject));
break;
  connection.encodeString(connection.getTimestampUtils().toString(null, (Time)valueObject));
break;
  connection.encodeString(connection.getTimestampUtils().toString(null, (Timestamp)valueObject));
break;

bindString(i, connection.getTimestampUtils().toString(cal, t), Oid.UNSPECIFIED); // Let the server infer the right type.

bindString(i, connection.getTimestampUtils().toString(cal, t), Oid.UNSPECIFIED); // Let the server infer the right type.

  connection.encodeString(connection.getTimestampUtils().toString(null, (Date)valueObject));
break;
  connection.encodeString(connection.getTimestampUtils().toString(null, (Time)valueObject));
break;
  connection.encodeString(connection.getTimestampUtils().toString(null, (Timestamp)valueObject));
break;