71,480 questions
1
vote
1
answer
145
views
created_at (server time) is sometimes earlier than clicked_at (client time) — why?
I’m tracking button clicks on my website and storing both client-side click time and server-side insert time in my database.
Frontend (JavaScript)
I capture the click timestamp like this:
clicked_at: ...
- 29
2
votes
1
answer
67
views
ImportError in old migrations (django.utils.timezone.utc) after upgrading Python and Django
I recently upgraded my project from Django 3.2 to Django 5.2 and also updated Python to 3.13.
During this process, I noticed that some of my old migration files do not explicitly import timezone from ...
- 21
0
votes
0
answers
79
views
Filtering based on date and time (POSIXct) in R (based on sunset and sunrise data) [duplicate]
I am trying to filter files based on the POSIXct format in R using tidyverse synthax.
What I need is to select all files that are within a timeframe between sunset and next sunrise for each day.
I ...
0
votes
1
answer
59
views
How to correctly manage date and timezone between frontend and database
I can't seem to find a definitive approach to this problem, lots of options, and pros/cons.
I have a medical app written in Flutter which captures the date and time a procedure was performed. The ...
- 148
1
vote
1
answer
118
views
Floor PHP date/time to top of hour [duplicate]
I want to be able to floor a time to the top of the hour, e.g. 14:50:35, becomes 14:00:00.
Either unix timestamp or DateTime/DateTimeImmutable, etc. is OK, but I cannot figure out how to do it. I ...
- 21
0
votes
2
answers
92
views
how to format a int column into HH:MM:SS.0 in polars
I have a column of numbers, and I want to add a column that changes this to HH:MM:SS
df = pl.DataFrame({"seconds": [1.0, 4562.2, 2.44,123.567]})
I have tried
df.with_columns(hhmmss=pl....
- 3,816
-1
votes
1
answer
93
views
API calls to api.weather.com - Daylight savings date format [closed]
I've been using api.weather.com to collect hourly weather information for some time and twice a year I have problems on the day when daylight savings time is enabled/disabled.
Here is the URL (these ...
- 61
0
votes
1
answer
83
views
Delete records from last day (switch midnight)
At the moment I delete records like this:
DELETE FROM users WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY)>=last_login
last_login = DATETIME field
This deletes records after 24 hours but it should ...
- 1,081
1
vote
2
answers
244
views
What does .NET DateTime Ticks represent when Kind is Unspecified?
Take the following C# code:
DateTime.TryParse("2025-05-03T02:10:36", out DateTime dateTime);
Console.WriteLine(dateTime.Kind);
Console.WriteLine(dateTime.Ticks);
The value of Ticks is here ...
- 34.6k
Advice
1
vote
10
replies
130
views
TimeSpan greater than "days" defined as ISO 8601 and subtracted/added to DateTime
I'm looking into a running timestamp based on a time span subtracted from a given datetime. The .NET documentation says TimeSpan can't go above days, but I need to be able to define a greater timespan....
- 531
2
votes
0
answers
66
views
Convert MJD UTC to python datetime or similar [closed]
I have a list of strings representing time in python, where time is given as MJD in UTC. Some have one decimal point, for instance '60781.94298115968', and some have two, for instance '60781....
0
votes
2
answers
102
views
DateTime.parse in flutter is converting passed string to UTC time
I am calling an API from a flutter application.
That API returns a DateTime field in a JSON object. That DateTime field contains local time, this way:
2026-02-01T13:43:08.3568212-03:00
The returned ...
- 4,563
1
vote
3
answers
114
views
Move time 1 hour back on range of rows in pandas
I have a dataset with a 'Time' column; for 2 dates the time is incorrect and I need to move it back by 1 hour.
This is what my dataframe looks like:
Date Time
05.01.2026 17:00
06.01.2026 ...
- 161
1
vote
2
answers
108
views
Date-time string with time span where ISO 8601 is expected
I'm developing an Android app, and I need to parse some external data. This data includes date-time values, and claims these values to be ISO 8601 compatible. While most of examples I encountered were ...
- 19
1
vote
1
answer
55
views
Plotly Express facets show no lines when setting x-axis range and custom tick labels
I have a dataframe with these columns:
id_pair (pair of sensors)
rssi_mean (detection strength)
contact_day (day of the detection as string, e.g. 'Monday')
study_week (week of the detection as ...
- 1,339