12,581 questions
2
votes
1
answer
47
views
Storing store time of day ranges where timezone matters
I need to store some store hours that exist in different time zones and may be interacted with in different timezones through an admin portal where it will display store time and local time.
I know ...
- 21
Best practices
0
votes
3
replies
135
views
Converting place/location into timezone
I am using XYZ geoLocation IP details provider API and it giving output in below format
{
"ipAddress": "66.XXX.YY.XXX",
"network": "66.XXX.YY.Z/AB",
...
- 312
1
vote
0
answers
38
views
Django timestamp__date filtering works locally but returns extra rows in production?
I have a Django API that returns self signedup users in a given date range. The AuditLog model stores timestamp with DateTimeField(default=timezone.now) and USE_TZ=True.
Locally, the date filter works ...
3
votes
1
answer
127
views
Noda Time reporting incorrect timezone (Unity - iOS/Android)
I'm working on a project where I need to get the current timezone of a device in IANA format in a Unity App for iOS and Android. I have so far tried using TimeZoneInfo which doesn't give the timezone ...
1
vote
1
answer
58
views
Trying to convert .NET Ticks to Central Time but without the offset
In a SELECT statement I want to convert .NET ticks to a datetime and display in Central Time. I don't want the timestamp+offset that "AT TIME ZONE 'Central Standard Time'" gives, I just want ...
- 13
1
vote
0
answers
88
views
Robocopy algorithm for /FFT and /DST options
Microsoft's Robocopy program has these two options:
/FFT :: assume FAT File Times (2-second granularity).
/DST :: compensate for one-hour DST time differences.
What is the exact algorithm that ...
- 3,610
0
votes
1
answer
109
views
Why is the time zone in Google Sheets set programmatically via Apps Script not reflected in settings of the spreadsheet?
I am trying to set a time zone for a Google spreadsheet programmatically.
function setTimezone() {
const name = 'test';
const file = getFileByName(name);
const ss = SpreadsheetApp.open(file);
...
- 407
3
votes
0
answers
224
views
How to get canonical IANA timezone ids in javascript
How would I get a list containing only and all canonical IANA time zone ids in javascript?
While I fully intend to support all IANA time zone ids in my application, when users select a timezone, I ...
1
vote
0
answers
29
views
GridDB time-series query skips rows with millisecond timestamps (Java API)
I'm testing GridDB Community Edition 5.3 (Linux container via Docker Desktop on macOS 14.4, Apple M1).
When I insert rows with millisecond timestamps into a time-series container, and query using a ...
0
votes
1
answer
93
views
Are DBT snaopshots using check strategy capture valid from/to as UTC?
I'm using dbt cloud to generate snapshots to track SCD on a table, uing the check strategy (as I don't have an updated_at column in my source table) - this works well, and every change captures a new ...
- 221
0
votes
0
answers
73
views
Configure NodeJS default time zone inside docker container [duplicate]
I'm having trouble to configure my node environment to use the same timezone as my docker container.
FROM node:20-alpine
WORKDIR /app
RUN apk add --no-cache chromium openssl tzdata
ENV TZ=America/...
0
votes
1
answer
92
views
Get the canonical timezone name of a backward linked timezone in python?
As title said, I'm looking for a simple way to get the canonical name of a timezone when providing a timezone name.
For example Asia/Calcutta is the backward liked name of Asia/Kolkata.
I'd expect ...
- 382
0
votes
1
answer
100
views
How to properly handle dates with Laravel?
So, I'm working with Laravel. My project is set to the TIMEZONE: UTC.
When I consume my project's API on a Flutter mobile application, for example, I convert the dates received from the server in UTC ...
3
votes
1
answer
134
views
Intl.DateTimeFormat: Why is timeZoneName: "shortOffset" is having a different value in different languages
We are currently exploring showing timestamps with time zone to our users and decided to go with the Intl.DateTimeFormat option timeZoneName: "shortOffset" but we now noticed that the value ...
- 2,011
0
votes
1
answer
85
views
Time Zone name to Internalization [duplicate]
Intl.supportedValuesOf('timeZone')
Above code will give list of all time zone in en-US like below
["Africa/Abidjan", "Africa/Accra" , "Africa/Addis_Ababa", ...]
Is ...
- 213
0
votes
0
answers
53
views
Chartkick time zone aware labels with time series
I'm using Chartkick 5.1.4 with Rails and code like the following in my view:
<%=
line_chart(
charts_data_last_1_hour_path,
:refresh => 60,
...,
:library => {
:scales =...
- 15.3k
2
votes
1
answer
66
views
Why datetime.datetime.strptime %Z code doesn’t produce an aware object?
A little example:
$ python
Python 3.13.2 (main, Feb 5 2025, 08:05:21) [GCC 14.2.1 20250128] on linux
Type "help", "copyright", "credits" or "license" for more ...
- 23
0
votes
1
answer
229
views
Invalid time zone in BigQuery
Since the last update in tzdata previous week (2025b - March 22, 2025), a new timezone named America/Coyhaique was introduced.
However, BigQuery still doesn't support it and produces an error when ...
- 3,587
-1
votes
2
answers
93
views
In Go language the API values are stored in UTC but I want to convert the UTC time to EST while accepting the API request
For example, at 10:30 PM Thursday, Eastern Time (ET) is 2:30 AM Friday, Universal Time (UTC)
My Api server is in EST time zone, so now I want to accept all the request until 11:59 PM EST time, but the ...
- 17
1
vote
1
answer
58
views
Investigating a Crash Report: .environment .timeZone
I have a crash report and I can’t figure out how to fix it, probably the main issue is that it's the first time I receive a crash report so I‘m not that expert on using it! (…so please, be kind!)
...
- 2,041
1
vote
2
answers
89
views
How to get current_timestamp in database timezone and not the session timezone in postgres
I have a column in my postgres table which stores the time at which row is inserted or modified in the database. I need to rely on current_timestamp method However it generates in session timezone and ...
1
vote
1
answer
59
views
What defines whether a given day is "workday" or "weekend"?
Throughout the world there isn't a consensus what a workweek should be. Western-centric world seems to define it as 5x2 (5 workdays, 2 weekend days), but they define their own "start of week"...
- 1,278
0
votes
0
answers
44
views
Yajra Datatables changes datetimes incorrectly
I am working on Laravel 11 app. I am using yajra/datatables and datetimes in the db are correct but however when yajra/datatables displays them in the frontend they are an hour behind? I've been ...
- 4,769
1
vote
0
answers
114
views
Why is Mongo subtracting 1 hour when it stores LocalDate?
I have a Java 17 record with a field:
@Field("enrollment_date")
@JsonFormat(shape = JsonFormat.Shape.STRING, pattern = "dd-MM-yyyy", timezone = "UTC" )
LocalDate ...
- 18.8k
0
votes
1
answer
44
views
Running the app with custom downloaded glibc gives seg fault [duplicate]
I downloaded custom glibc and then compiled using g++ dt.cpp -std=c++11 -Wl,-rpath "/opt/glibc-2.28/lib", but it gives seg fault
#include <iostream> ...
- 318