Export (0) Print
Expand All
Expand Minimize

setDateTimeOffset(int, java.sql.DateTimeOffset) (SQLServerStatement)

Sets the designated parameter to the given DateTimeOffset value.


public void setDateTimeOffset(int parameterIndex, DateTimeOffset dateTime)

parameterIndex

Index of the column to set.

dateTimeOffset

A DateTimeOffset object.

The DateTimeOffset format is "YYYY-MM-DD HH-MM-SS[.nnnnnnn] [+][-] HH:MM". Use the following table for reference.

SQL Type

Insert

datetime

May only insert: "YYYY-MM-DD hh:mm:ss[.nnn]"

smalldatetime

May only insert: "YYYY-MM-DD hh:mm:ss"

Time

May only insert: "hh:mm:ss[.nnnnnnn]"

Date

May only insert: "YYYY-MM-DD"

DateTime2

May only insert: "YYYY-MM-DD hh:mm:ss[.nnnnnnn]"

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft