SqlServerTimeZoneSupport | IANA Time Zone Support for Microsoft SQL Server | SQL Database library

by mj1856 C# Version: 1.0.1 License: MIT

X-Ray Key Features Code Snippets Community Discussions(1)Vulnerabilities Install Support

kandi X-RAY | SqlServerTimeZoneSupport Summary

SqlServerTimeZoneSupport is a C# library typically used in Database, SQL Database applications. SqlServerTimeZoneSupport has no bugs, it has no vulnerabilities, it has a Permissive License and it has low support. You can download it from GitHub.

IANA Time Zone Support for Microsoft SQL Server

Support

Quality

Security

License

Reuse

Support

SqlServerTimeZoneSupport has a low active ecosystem.

It has 167 star(s) with 35 fork(s). There are 24 watchers for this library.

It had no major release in the last 12 months.

There are 15 open issues and 12 have been closed. On average issues are closed in 62 days. There are 4 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of SqlServerTimeZoneSupport is 1.0.1

Quality

SqlServerTimeZoneSupport has 0 bugs and 0 code smells.

Security

SqlServerTimeZoneSupport has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

SqlServerTimeZoneSupport code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

SqlServerTimeZoneSupport is licensed under the MIT License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

SqlServerTimeZoneSupport releases are available to install and integrate.

Installation instructions, examples and code snippets are available.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of SqlServerTimeZoneSupport

Get all kandi verified functions for this library.

SqlServerTimeZoneSupport Key Features

No Key Features are available at this moment for SqlServerTimeZoneSupport.

SqlServerTimeZoneSupport Examples and Code Snippets

No Code Snippets are available at this moment for SqlServerTimeZoneSupport.

Community Discussions

Trending Discussions on SqlServerTimeZoneSupport

ConvertZone() returns NULL using TZDB SQL Server Zone Support

QUESTION

ConvertZone() returns NULL using TZDB SQL Server Zone Support

Asked 2021-Apr-19 at 02:32

We are running SQL Server 2008 R2, so for Timezone stuff we use Matt Johnson's SqlServerTimeZoneSupport/ We convert datetimes on the fly using ConvertZone for our clients. Some Australian states support Daylight Savings, some don't. Upgrading SQL Server is not possible.

I'm trying to solves an issue where ConvertZone() is returning null for dates in the last week. Probably related to daylight savings. I've tried fiddling with the spring forward and fall back bits to no success.

Listed below is a test case:

...

ANSWER

Answered 2021-Apr-19 at 02:32

@matt-johnson-pint suggested I refresh my Timezone tables. This involved downloading and using the SqlTzLoader from the Project page, running for each server (set the correct connection string). I was confused, as it outputs no text if successful, but it fixed the issue. My test case is now fine.

Source https://stackoverflow.com/questions/67052033

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install SqlServerTimeZoneSupport

Download the latest sqltz.zip file from the releases page. Extract the zip file to a directory. Open the tzdb.sql file, and run it against your database.
Download the latest sqltz.zip file from the releases page.
Extract the zip file to a directory.
Open the tzdb.sql file, and run it against your database. It will create all objects in an independent schema called [Tzdb]. Microsoft SQL Server 2008 R2 and higher are supported, including Azure SQL Database.
Run the SqlTzLoader.exe utility, passing the connection string with the -c parameter. For example: SqlTzLoader.exe -c"Server=YourServerName;Database=YourDatabaseName;Trusted_Connection=True" or SqlTzLoader.exe -c"Server=YourServerName;Database=YourDatabaseName;User Id=foo;Password=bar" It will download the latest time zone data and populate the tables in the database.

Support

This project adds full support for time zones to Microsoft SQL Server. This implementation uses the industry standard IANA time zone database. If you are used to Microsoft Windows time zones, such as used with .NET TimeZoneInfo, consider using IANA time zones by using the Noda Time library. You can read more about the IANA time zone database on Wikipedia, and on StackOverflow. Note: This is an un-official, personal project. It is not developed or supported by Microsoft.

Find more information at: