IPreparedStatement.SetTimestamp Method

Definition

Overloads

SetTimestamp(Int32, Timestamp)

Sets the designated parameter to the given java.sql.Timestamp value.

SetTimestamp(Int32, Timestamp, Calendar)

Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object.

SetTimestamp(Int32, Timestamp)

Sets the designated parameter to the given java.sql.Timestamp value.

[Android.Runtime.Register("setTimestamp", "(ILjava/sql/Timestamp;)V", "GetSetTimestamp_ILjava_sql_Timestamp_Handler:Java.Sql.IPreparedStatementInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public void SetTimestamp (int parameterIndex, Java.Sql.Timestamp? x);
[<Android.Runtime.Register("setTimestamp", "(ILjava/sql/Timestamp;)V", "GetSetTimestamp_ILjava_sql_Timestamp_Handler:Java.Sql.IPreparedStatementInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member SetTimestamp : int * Java.Sql.Timestamp -> unit

Parameters

parameterIndex
Int32

the first parameter is 1, the second is 2, ...

x
Timestamp

the parameter value

Attributes

Exceptions

if a database error happens.

Remarks

Sets the designated parameter to the given java.sql.Timestamp value. The driver converts this to an SQL TIMESTAMP value when it sends it to the database.

Java documentation for java.sql.PreparedStatement.setTimestamp(int, java.sql.Timestamp).

Portions of this page are modifications based on work created and shared by the Android Open Source Project and used according to terms described in the Creative Commons 2.5 Attribution License.

Applies to

SetTimestamp(Int32, Timestamp, Calendar)

Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object.

[Android.Runtime.Register("setTimestamp", "(ILjava/sql/Timestamp;Ljava/util/Calendar;)V", "GetSetTimestamp_ILjava_sql_Timestamp_Ljava_util_Calendar_Handler:Java.Sql.IPreparedStatementInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public void SetTimestamp (int parameterIndex, Java.Sql.Timestamp? x, Java.Util.Calendar? cal);
[<Android.Runtime.Register("setTimestamp", "(ILjava/sql/Timestamp;Ljava/util/Calendar;)V", "GetSetTimestamp_ILjava_sql_Timestamp_Ljava_util_Calendar_Handler:Java.Sql.IPreparedStatementInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member SetTimestamp : int * Java.Sql.Timestamp * Java.Util.Calendar -> unit

Parameters

parameterIndex
Int32

the first parameter is 1, the second is 2, ...

x
Timestamp

the parameter value

cal
Calendar

the Calendar object the driver will use to construct the timestamp

Attributes

Exceptions

if a database error happens.

Remarks

Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object. The driver uses the Calendar object to construct an SQL TIMESTAMP value, which the driver then sends to the database. With a Calendar object, the driver can calculate the timestamp taking into account a custom timezone. If no Calendar object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.

Added in 1.2.

Java documentation for java.sql.PreparedStatement.setTimestamp(int, java.sql.Timestamp, java.util.Calendar).

Portions of this page are modifications based on work created and shared by the Android Open Source Project and used according to terms described in the Creative Commons 2.5 Attribution License.

See also

Applies to