71,480 questions
0
votes
0
answers
34
views
SSRS Date parameter works in Query designer but not in the report
I have a Date field in my dataset query - INCIDENTDATE. I use a Date parameter :P_INCIDENT_DATE to find a match in the query. When I use query designer to check if the parameter works in my query, I ...
- 975
0
votes
2
answers
79
views
Putting a time interval on x axis
I tried to make a graph using gnuplot where I want to plot a price over a time period (4 am to 10 pm but over a larger time period). My input has a date-time column and a price column:
$Data << ...
- 11
1
vote
1
answer
148
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
73
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
81
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
60
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
120
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
93
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
249
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
132
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
67
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
106
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,564
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
109
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
56
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
0
votes
0
answers
59
views
Swift decoding error on date type based on user settings preferences (time format) [duplicate]
Recently I have noticed that an API which return a reponse that contains some date type are failing if I have a 12 hour format (AM/PM) on my phone enable iOS 17.6.1. If I switch to 24 hour format the ...
2
votes
2
answers
208
views
C++ hinnant date lib - not parsing string to date under Linux, works on Windows
If I do:
#include <chrono>
#include "./date/date.h"
#include "./date/tz.h"
using UtcTime = std::chrono::time_point<std::chrono::system_clock>;
UtcTime xParseRfc822(...
- 9,663
1
vote
2
answers
92
views
Why does Matplotlib DatetimeIndex plot misalign dates?
Why does matplotlib round to the nearest month sometimes and not other times depending on the order lines are plotted and which dates are used. ax3 and ax4 are particularly interesting because they ...
- 546
Tooling
1
vote
3
replies
69
views
Python delta time series conversion to time data type
I have a column named ride_length that is the difference between two datetime columns. It has a data type of time delta series. How can I convert it into a time data type?
Current format 1 day 12:58:...
1
vote
1
answer
102
views
How to find corrupted date entry when date column type is (object) [closed]
I am trying to convert a column of time stamps that are currently of type object to proper datetime. When using pd.to_datetime() on the column I got this error
OutOfBoundsDatetime: Out of bounds ...
- 1,345
1
vote
1
answer
66
views
wrong results with DateTime/IntlDateFormatter on certain Dates
I try to introduce an alternative way to localize Date expressions using IntlDateFormatter with DateTime.
There is a strange behaviour depending on the day that I use. So I must have done an error in ...
- 15
0
votes
0
answers
72
views
VB Net WinForms Chart Zoom In with DateTime as X Axis
I am a newbie at VB.NET coding. I am currently trying to make a real time line chart in WinForms, but I am struggling with zooming in the chart. My chart has the range of random number generated by a ...
- 11
1
vote
1
answer
142
views
Calculations from Timestamp based on Checkbox Iterative now() in Google Sheets
I don't want to use Google Apps Scripts, just formulas so that this can be display/edited on a mobile device while offline.
[
- 23
-1
votes
1
answer
106
views
ParseExact Exception [closed]
I have power shell code which extracts a date from a different source and converts it:
$dtStart = [DateTime]::ParseExact($StartDate.toString().Substring(0, 10).Trim(), 'M/d/yyyy', $null).ToString('dd/...
- 3,344
1
vote
0
answers
134
views
Polars parse multiple datetime format [duplicate]
I have string column in polars dataframe with multiple datetime formats and I am using following code to convert datatype of column from string into datetime.
import polars as pl
df = pl.from_dict({'...
- 3,145
1
vote
1
answer
139
views
Problem converting a column to datetime format
I have a data frame and I am trying to convert the time column into a datetime format. The first step I did was:
data['time'] = data.time
data['time']=pd.to_datetime(data['time'], format='%H:%M:%S.%f')...
2
votes
4
answers
236
views
Flag rows if the time in a column falls within a specified window of another column
I have a dataframe where each row represents a detection of a fish. The fish can be either, Brown Trout (Fish.ID starts with TB_) or Salmon/Parr (Fish.ID starts with TA_). I want to create a new ...
- 756
1
vote
1
answer
131
views
Different epoch time from the same datetime
Here is my code:
import pandas as pd
import datetime
df = pd.DataFrame({'str_date': ['2023091004']})
df['epoch'] = pd.to_datetime(df['str_date'], format='%Y%m%d%H').astype(int) // 10**9
dt = ...
- 7,864
0
votes
1
answer
48
views
TypeError: can't compare datetime.datetime to str when filtering data in Python [duplicate]
I have a list of records where each item has a date field. I'm trying to filter the records based on a given date:
from datetime import datetime
records = [
{"name": "John", &...
-3
votes
2
answers
225
views
String not recognized as a valid DateTime
I'm receiving this date and time in US format from an upstream server I have no control over and can't change: 12/16/2024 11:30:23 AM
I am trying to convert it to UK format using PowerShell:
[DateTime]...
- 3,344
4
votes
1
answer
160
views
Python datetime and timedelta behaviour over Daylight savings time change
I encountered this behaviour and I figured I would ask the correct way to go about it.
Here is a toy example:
pre_timechange = datetime.datetime(2025, 11, 2, 1, 59, 9, tzinfo=zoneinfo.ZoneInfo(key='...
- 61
0
votes
2
answers
94
views
How to send a literal time to a Salesforce Time field from DataWeave without timezone conversion?
I'm using MuleSoft to send data to a Salesforce custom object. My object has a field named Shift_End_Time__c, and its data type is Time.
My source system provides this time as a string in UTC format, ...
-2
votes
1
answer
76
views
Timedelta Unit Argument as a Variable [duplicate]
Is it possible to have the units argument for the timedelta function be defined by a variable?
To elaborate, is this possible?
Time_Unit = "days"
Time_Increment = 1
Time2 = Time1 + ...
- 53
3
votes
0
answers
329
views
How to convert epoch to datetime in Datadog dashboard?
I have a Datadog dashboard displaying the metrics we get for our AWS Glue Zero-ETL integrations. One of those is lastSyncTimestamp, the epoch timestamp until which source has been synced to target.
I ...
- 31
4
votes
2
answers
132
views
Django difference between aware datetimes across DST [duplicate]
I'm working on a Django application in which I need to calculate the difference between timestamps stored in the DB. This week I run into some problems related to DST.
In particular in the following ...
- 43
3
votes
1
answer
87
views
Explicit formatting of Format date/time regardless of operating system setting
As an an example:
print(os.date("%b"))
This prints "Oct" when running on a computer having date time settings set to English.
When using other language it prints "okt" (...
- 53
0
votes
1
answer
142
views
How can I retrieve data between certain times?
My data decoded from a radio receiver is stored in tables Flights and Aircraft with a common field AircraftID to enable a JOIN. There are fields for when the radio signal starts and ends (StartTime ...
- 3
0
votes
1
answer
78
views
Date & time not being shown in japanese
I am using IBM MQ on a Windows 11 machine that was originally installed with the Japanese language pack—in other words, unlike the typical en-US installation, mine came with Japanese as the default. ...
- 41
0
votes
1
answer
113
views
Combining two dataframes and keeping the average
I'm new to coding, and I'm trying to combine the data from two weather stations into one new dataframe sorted by Datetime. I want this new dataframe to contain the average values of the two original ...
1
vote
1
answer
155
views
Pandas's to_datetime function and datetime format
I have a .csv file with two columns (Date and Time). The time zone is "Europe/Paris" with a +02:00 hours shift. The file is structured in 2 parts with two datetime formats.
Date
Time
08-11-...
- 77
3
votes
1
answer
166
views
GraalVM native-image localized data/time data
Given this sample:
final var ARABIC_GREGORIAN_DATE_FORMATTER = DateTimeFormatter.ofPattern("EEEE dd\\MM\\yyyy G").localizedBy(Locale.forLanguageTag("ar"));
final var ...
- 118k
1
vote
2
answers
167
views
How do I calculate a relative time delta in Pandas?
I have a column of datetimes and I want to get the difference between values in terms of years, months, etc, instead of timedeltas that only provide days. How do I do this in Pandas?
Pandas provides ...
- 34.2k
3
votes
3
answers
168
views
Calculating monthly revenue given start and end date for each ID using Polars
I have a dataframe using this format
import polars as pl
df = pl.from_repr("""
┌─────┬────────────┬────────────┬──────────┐
│ ID ┆ DATE_PREV ┆ DATE ┆ REV_DIFF │
│ --- ┆ --- ...
- 65
0
votes
1
answer
79
views
Vaadin 24 Datetimepicker in one field
Is it possible to display the date and time selection field in one field instead of two?
How can I get a separate calendar and time selection component (only what is raised by clicking on the field)?
...
- 337
-2
votes
1
answer
174
views
How to display local time from a UTC time [closed]
I have some data with date time in UTC. My local time is usually 5 or 6 hours behind depending on standard or daylight time. I would like to print the local time.
Is there an easy way to do that in ...
- 439
1
vote
0
answers
44
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 ...
0
votes
2
answers
138
views
How to get the current UTC date in Python as a type of datetime.datetime
I would like to use the Python standard library datetime to assign to a variable the current date, in UTC and having it of type datetime.datetime.
i.e. datetime.datetime(2025, 9, 23, 0, 0, tzinfo=...
- 4,349
1
vote
1
answer
64
views
Python: Converting string in NZ summer time to UTC gives wrong result
I am creating a simple script where I need to convert
strings with date and time given in NZ time to corresponding
UTC time.
The time series are done in NZ summer (Dec-Feb) and hence the
NZ time is 13 ...
- 293