title	setDateTimeOffset(int, java.sql.DateTimeOffset) \| Microsoft Docs
ms.custom
ms.date	01/19/2017
ms.prod	sql
ms.prod_service	connectivity
ms.reviewer
ms.technology	connectivity
ms.topic	conceptual
ms.assetid	e8b6e380-6b53-489b-be73-73fcb5258269
author	David-Engel
ms.author	v-daenge

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

Sets the designated parameter to the given DateTimeOffset value.

Syntax

  
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]"