Questions tagged [timezone]
A time zone is a region on Earth that has a uniform, legally mandated standard time. It is often represented by an identifier, such as "America/Los_Angeles". Do not mistake an offset such as -07:00 as a time zone. A time zone is much more than that. Please read the entire tag wiki for details.
timezone
12,466
questions
0
votes
1
answer
12
views
Creating bigquery tables with expiration option leads to unexpected expiration time
I'm creating a table in GBQ with an expiration timestamp as following:
CREATE OR REPLACE TABLE
`myproject.mydataset.testtable`
OPTIONS (expiration_timestamp=TIMESTAMP(DATE_ADD(CURRENT_DATE(), ...
- 1,646
-1
votes
1
answer
102
views
Changing time zone doesn't make LocalTime.now() returns different value, why?
Recently I created a VM on Google Cloud Platform to run my .jar 24/7, and a part of my code is like:
if (LocalTime.now().getHour() == 0)
whenDateChanged();
I noticed that it runs at 12 am UTC+0, ...
- 33
1
vote
1
answer
30
views
Are all time zone identifier strings in 7-bit ASCII?
In other words, can the timezone column in my database have latin1 encoding?
Important to know since the time zone identifiers will be coming from user devices and the database will throw an error if ...
- 12.1k
-6
votes
1
answer
47
views
how to extract the local time and year when given a UTC time in milliseconds and the timezoneOffset?
In javascript, one is given:
UTC milliseconds since 1970
timezoneOffset of the local timezone
From the above, how to extract the local time and year implied by the timezoneOffset?
0
votes
2
answers
26
views
How to configure javascript pg library to interpret timestamps without timezone as UTC timestamps when reading from postgres
My computer timezone offset is UTC/GMT +3 hours.
My table in database is defined as such.
CREATE TABLE public.order_invoices (
created_at timestamp NOT NULL,
updated_at timestamp NOT NULL,
...
- 194
0
votes
0
answers
30
views
Storing time and timezone data in PostgreSQL
Our users should be able to configure a time-in-day, and a timezone, by which they want to get daily updates. The updates should contain data that will be presented in their timezone of choice. For ...
- 3,823
1
vote
0
answers
30
views
Save DateTime in mysql database based on Asia/Tehran time zone
I have a Django project where I have used a DateTime field in one of its models.
In this database field, I want to save the date and time of this moment.
Also, my database is mysql type and on the ...
-3
votes
0
answers
122
views
Java Date.toString() method produces two different results on different linux servers
We are getting org.postgresql.util.PSQLException: ERROR: invalid input syntax for type timestamp: "Wed Jun 26 23:27:35 TRT 2024" as an exception when our application tries to insert the ...
- 35
1
vote
0
answers
42
views
Issue on date Handling || Time travel Bugs || Middleware || Better Approach
Issue:
The server defaults to the African time zone, and the user receives their time in this zone, despite the existence of middleware in the PHP Laravel code.
class UpdateTimezoneMiddleware
{
/**...
1
vote
1
answer
26
views
Dayjs wrong timezone conversion
// DATE = 2024-06-13T23:59:59+05:00
let dateTime = dayjs(date, format, locale, strict);
// +05 UTC OFFSET
dateTime = dateTime.utcOffset(300);
console.log('1 - ', dateTime.format());
// ...
- 31
0
votes
1
answer
33
views
How to set timezone for ActiveRecord queries to fetch the accurate figures?
I am building a Rails 7 app that is targetted for the German audience.
My current local German time is Fri Jun 21 12:10:23 CEST 2024 (output from date in terminal). When I log in to my production ...
- 47.7k
0
votes
0
answers
22
views
python datetime timezone converted is not really changing anything except the timezone label? [duplicate]
I am US/Pacific timezone (and my devices are too).
import time
import pytz
from datetime import datetime
from datetime import timezone
from zoneinfo import ZoneInfo
tz_pac = pytz.timezone('US/Pacific'...
- 33
1
vote
0
answers
32
views
Why does the events in RRule offset by whole 1 day in cases where timezone conversion to UTC was next day?
I have a calendar that shows the recurring events using the RRule. I am on PST timezone so the calendar is also on PST.
When I create a RRule with dtstart where the PST to UTC conversion DOES NOT ADD ...
- 300
4
votes
4
answers
95
views
Does anyone know PHP code to correct the conflictive time change in a country?
For example, when a country changes time, there are 2 possibilities:
1.- If it changes to an earlier time, for example, at 3 Am in Central Europe, the last Sunday in October at 3 Am becomes 2 Am, ...
1
vote
3
answers
76
views
issue with time zones in dataframe and POSIXct data
I have a bunch of timedates with different time zones - I am able to generate a dataframe with these as different columns. It looks something like this:
timedate <- c("2024-03-31T03:14:00"...
- 15