Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Sets the designated parameter to the given DateTimeOffset value.
Syntax
public void setDateTimeOffset(int parameterIndex, DateTimeOffset dateTime)
Parameters
parameterIndex
Index of the column to set.
dateTimeOffset
A DateTimeOffset object.
Exceptions
Remarks
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]" |
See Also
getDateTimeOffset (SQLServerResultSet)
SQLServerStatement Members
SQLServerStatement Class