python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - timezone-offset

How to handle incorrect system time (offset from the system timezone) on device?

I know this is a relatively popular question, but the answers which I found didn't cover the following use case: Let's consider that a user has Europe/Moscow timezone set on device which means it is G...
test-img

Daniil Kunin

ios

react-native

timezone

momentjs

timezone-offset

Votes: 0

Answers: 0

SQL Server 2019 on Linux Time Zone Problem

Why there are different results (offset should be +03:00): SELECT CURRENT_TIMEZONE() as [CURRENT_TIMEZONE()] , SYSDATETIMEOFFSET() as [SYSDATETIMEOFFSET()]; result is : CURRENT_TIMEZONE() ...
test-img

Ali Rıza Arslan

sql-server

timezone

timezone-offset

sql-server-2019

sql-server-linux

Votes: 0

Answers: 1

Latest Answer

I realized SQL Server does not care Turkey adopted +03:00, does not use daylight saving and got a temporary solution. SQL Server does not work properly for Europe/Istanbul so I set Europe/Moscow same ...
test-img

Ali Rıza Arslan

Rails MySQL Active Record Time Zone Not Being Recognized

I'm having an issue with timezones not pulling through correctly in my searches. When I print out the actual timezone before passing to active record it shows correctly. ex: date = params[:date].split...
test-img

Eric Reynolds

mysql

ruby-on-rails

date

activerecord

timezone-offset

Votes: 0

Answers: 1

Latest Answer

I was able to get it working by changing @date = DateTime.new(date[0].to_i, date[1].to_i, date[2].to_i) to @date = Date.new(date[0].to_i, date[1].to_i, date[2].to_i) and adding group_by_second(:cre...
test-img

Eric Reynolds

How to get date time using time zone offset in js

I have a time zone offset like -7 now I want the date-time of that particular offset? How Can I get this in js? Thanks.
test-img

Benk I

javascript

datetime

time

timezone

timezone-offset

Votes: 0

Answers: 1

Latest Answer

Javascript's dateObj.getTimezoneOffset() method returns the time-zone offset in minutes for the current locale. The time-zone offset is the minutes in difference, the Greenwich Mean Time (GMT) is rela...
test-img

SUBHAM MAJI

Posts

Questions

Blogs

Jobs