ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Goal: Establish a consistent policy for how DateTime::TimeZone resolves ambiguous local times that occur during daylight‑saving‑time fallback when no explicit disambiguation is supplied. Constraints: The module currently leaves the interpretation to the caller, which can lead to different results across systems or when using outdated tzdata. Additionally, Da
Problem Statement SPSS stores datetime values as seconds since 1582‑10‑14 without any timezone information. Built‑in functions assume the value represents local wall‑clock time, and no automatic daylight saving time (DST) adjustments are applied. When importing timestamps from sources with explicit time zones (e.g., PostgreSQL TIMESTAMPTZ) the resulting SPSS
The goal is to convert SDL_GetTicks64 elapsed milliseconds into a regional wall-clock date-time for application logging and scheduled events. SDL_GetTicks64 is a monotonic counter that starts at SDL initialization and has no relationship to the Unix epoch, an IANA time zone, or daylight saving rules. SDL provides no civil date formatting or time zone databas
Handling Regional Time Zones in MySQL A common architectural challenge in MySQL involves choosing between TIMESTAMP and DATETIME when the application must support users across multiple regional time zones. The goal is to ensure that a single event is recorded once but displayed accurately according to the local time of each viewing user. Constraints and Beha
Date and time zone conversion in R The goal is to reliably convert a character string such as "2021-11-07 01:30" to a POSIXct object while preserving the intended local time semantics, particularly around daylight‑saving transitions. Current constraints and uncertainty When the tz argument is omitted, as.POSIXct defaults to the system time zone, producing no
Goal I need to know whether MATLAB datetime subtraction across a historical leap second returns the calendar-day difference or the true elapsed SI time, and whether any release-specific flag or function changes this behavior. Constraints MATLAB datetime objects use the proleptic Gregorian calendar and define one day as exactly 86,400 seconds. Arithmetic betw
Goal We want to reliably convert local timestamps that may fall within DST gaps into Stata datetime values while preserving the original regional context. Constraints The clock() function uses the session’s tz setting and returns . for times that do not exist during a spring‑forward transition. The stored value is a UTC‑based millisecond count with no zone m
Goal: Provide consistent date and time formatting for users regardless of whether the device’s system tzdata package is present or up to date. Constraints: When tzdata is missing, ZoneId.systemDefault() falls back to GMT and logs a warning; SimpleDateFormat and DateTimeFormatter can produce different zone name strings via ICU; manufacturers may replace or om
Goal: Obtain the same instant‑to‑zone conversion result when a DateTime value with Kind.Unspecified is passed to TimeZoneInfo.ConvertTime on both Windows and Linux. Constraint: The current implementation treats Unspecified as the local time zone of the process, which can produce different offsets if the value actually represents UTC, especially in cloud‑nati
sdl
r
stata
android