IPreparedStatement.SetDate Method

Definition

Overloads

SetDate(Int32, Date, Calendar)

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

SetDate(Int32, Date)

Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application.

SetDate(Int32, Date, Calendar)

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

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

Parameters

parameterIndex
Int32

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

x
Date

the parameter value

cal
Calendar

the Calendar object the driver will use to construct the date

Attributes

Exceptions

if a database error happens.

Remarks

Sets the designated parameter to the given java.sql.Date value, using the given Calendar object. The driver uses the Calendar object to construct an SQL DATE value, which the driver then sends to the database. With a Calendar object, the driver can calculate the date 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.setDate(int, java.sql.Date, 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

SetDate(Int32, Date)

Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application.

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

Parameters

parameterIndex
Int32

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

x
Date

the parameter value

Attributes

Exceptions

if a database error happens.

Remarks

Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application. The driver converts this to an SQL DATE value when it sends it to the database.

Java documentation for java.sql.PreparedStatement.setDate(int, java.sql.Date).

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