JDBC Driver for NetSuite

Build 22.0.8462

UserTimezoneOffset

Your user timezone offset as defined in your NetSuite preferences under Home --> Preferences --> Time Zone. Ex: EST.

Data Type

string

Default Value

""

Remarks

NetSuite returns dates and times offset based on your user timezone preferences. This applies only to Date and Time objects, not DateTime, which always return the same way no matter your preferences. We attempt a best effort to automatically correct for this and return dates as they would appear in the NetSuite UI. However, this is not 100% perfect due to how a few time zones are offset by 24 hours or greater depending on daylight savings time. If your user preferences are set to +13:00, +12:00, or -12:00, this value must be specified to get dates to show up correctly. For other offsets it is not required but recommended for best accuracy.

When retrieving Time values, this property is only needed if the time on the local machine does not match the logged in user. To check, log into the NetSuite UI, mouse over the home icon, and select Preferences. The user's timezone offset will be specified there. If you are in a situation where the local machine the CData JDBC Driver for NetSuite will execute on is not going to match the same timezone, set for the user, set the UserTimezoneOffset to match what is specified in the user preferences in NetSuite.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462