Timeline for Does changing server time zone "shift" SQL Server stored date / time values in ODBC / JDBC?
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 7, 2023 at 18:33 | comment | added | gavenkoa | I didn't see translation options for JDBC in SQL Server: learn.microsoft.com/en-us/sql/connect/jdbc/… Haven't checked jTDS and other libs. I'm looking to guaranties SQL Server provides, related to TZ settings... | |
| Mar 7, 2023 at 16:06 | comment | added | Eric Prévost | Depending on specific JDBC or ODBC drivers, platform or framework, there could be options to automatically translate datetime value to client's time zone, but it's not a feature part of JDBC/ODBC drivers provided by Microsoft, as far as I know. Could you give more details about the setup where you experienced that behaviour? | |
| Mar 7, 2023 at 15:05 | comment | added | gavenkoa |
Are JDBC / ODBC drivers affected by SQL Server time zone? I see that changing client time zone changes datetime2 saved/retrieved value. Does SQL Server communication protocol insensitive to a server timezone?
|
|
| Mar 7, 2023 at 14:21 | history | answered | Eric Prévost | CC BY-SA 4.0 |