Tag

Timezones

1 views collected around this technical thread.

Java Tech Enthusiast
Java Tech Enthusiast
Apr 8, 2025 · Databases

Choosing the Right Date/Time Storage Type in MySQL and PostgreSQL

Choosing the proper MySQL or PostgreSQL date/time column—avoiding string types, understanding DATETIME’s literal storage versus TIMESTAMP’s automatic UTC conversion, considering PostgreSQL’s TIMESTAMP WITH/WITHOUT TIME ZONE equivalents, and weighing numeric Unix timestamps for speed—ensures correct time‑zone handling, storage efficiency, and future‑proof range.

DatabaseDateTimePostgreSQL
0 likes · 12 min read
Choosing the Right Date/Time Storage Type in MySQL and PostgreSQL
Test Development Learning Exchange
Test Development Learning Exchange
Aug 15, 2024 · Backend Development

APScheduler Advanced Features and Configuration Examples

This article provides comprehensive examples of APScheduler's advanced features including database storage, multi-threading/multi-processing, event listeners, dynamic task management, external event triggers, priority settings, logging, advanced triggers, and timezone support.

Backend DevelopmentCron TriggersDatabase Storage
0 likes · 6 min read
APScheduler Advanced Features and Configuration Examples
UC Tech Team
UC Tech Team
Sep 26, 2018 · Frontend Development

Understanding Date and Time Handling in JavaScript for Internationalization

This article explains JavaScript date and time concepts—including GMT, UTC, ISO 8601, RFC2822, timestamps, parsing, formatting, timezone offsets, localization, and practical internationalization strategies—providing developers with the knowledge to correctly manage time across different regions and platforms.

DateJavaScriptTimezones
0 likes · 12 min read
Understanding Date and Time Handling in JavaScript for Internationalization