current_timezone was: ISO-8601 & Birgitta's Solution -- MIDRANGE-L

Subject: current_timezone was: ISO-8601 & Birgitta's Solution
From: Rob Berendt <rob@xxxxxxxxx>
Date: Mon, 3 Feb 2020 20:01:26 +0000
List-archive: <https://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@lists.midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.lists.midrange.com>
List-post: <mailto:midrange-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=unsubscribe>

This had me thinking about current_timezone again.
If I run
Values current_timezone;
On IBM i I will get back something like -50000 during Eastern Standard Time and -40000 during Eastern Daylight Time.

What does SQL server return? Will it vary according to the time of the year or is it something you just have to know to adjust? What I'm reading is this:
https://docs.microsoft.com/en-us/sql/t-sql/functions/current-timezone-transact-sql?view=sql-server-ver15

Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

RE: current_timezone was: ISO-8601 & Birgitta's Solution , Birgitta Hauser
Re: current_timezone was: ISO-8601 & Birgitta's Solution , John Yeung

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.