This article explains why the long‑standing java.util.Date class is problematic for modern Java development, illustrates its design flaws with concrete code examples, and shows how the Java 8 java.time API provides a clearer, immutable, and timezone‑aware alternative for handling dates and times.
DateTimeImmutable, introduced in PHP 5.5, offers immutable date objects that prevent side‑effects and improve code safety, while DateTime remains mutable; the article compares their behaviors, shows practical examples, outlines risks of mutability, and provides guidance on when to use each class.
This article introduces the Carbon library—a fluent, human‑readable wrapper for PHP's DateTime—explaining why it simplifies date calculations, how to install it via Composer, and demonstrating core concepts, common APIs, advanced features, and performance best practices with concrete code examples.
A Java backend service was unexpectedly showing a three‑day unblocking date instead of two, due to a one‑second overflow when converting LocalDateTime to java.util.Date for a PostgreSQL timestamp column, and the article walks through diagnosis, replication, and two practical fixes.
This article explains the five MySQL temporal column types—DATE, DATETIME, TIMESTAMP, YEAR, and TIME—detailing their storage size, valid ranges, typical use‑cases, timezone behavior, and the 2038 problem, helping developers pick the most suitable type for any scenario.
This article compares MySQL's INT, TIMESTAMP, and DATETIME column types, explaining their limits, default behaviors, timezone handling, performance implications, and best‑practice recommendations for storing temporal data in modern applications.
A Java backend bug caused blacklist unblocking times to be stored one second later than expected due to mismatched Date and TIMESTAMP precision, daylight‑saving and timezone conversions, and millisecond rounding, which was diagnosed through code review, AI analysis, and batch testing, then fixed by normalising nanoseconds or adjusting database column precision.
This article explains why storing dates as strings is inefficient, compares MySQL DATETIME and TIMESTAMP—including timezone handling and performance trade‑offs—shows practical SQL examples, adds PostgreSQL equivalents, and offers concise recommendations for selecting the optimal time storage format.
This tutorial explains how to use PHP's time(), date(), strtotime(), and date_default_timezone_set() functions to retrieve the current timestamp, format dates, perform date arithmetic, and configure timezones, providing practical code examples for each operation.
This article explains why storing dates as strings is inefficient, compares MySQL DATETIME, TIMESTAMP, and numeric Unix timestamps—including storage size, range, timezone handling, and performance—and adds PostgreSQL equivalents and practical recommendations for selecting the appropriate type.
This article presents twenty practical Python datetime examples covering current time retrieval, formatting, date arithmetic, leap year checks, timers, scheduling, calendar queries, timestamp conversions, and weekday calculations, each accompanied by clear code snippets for immediate use.
This article consolidates essential Java date and time utilities—including start/end calculations for days, weeks, months, quarters and years, time arithmetic, formatting, parsing, and conversions between LocalDateTime, Date, and Instant—providing a handy reference for developers working with the Java Time API.
This article explains why storing dates as strings is inefficient, compares MySQL DATETIME and TIMESTAMP—including storage size, range, timezone handling, and performance—and discusses when to use numeric Unix timestamps or PostgreSQL equivalents for reliable time data management.
This article provides a comprehensive collection of Python code snippets demonstrating how to obtain, format, convert, calculate differences, and perform various operations with dates and times, including timers, scheduling, and weekday handling.
When storing dates in MySQL or PostgreSQL, avoid VARCHAR fields and select between DATETIME (no time‑zone, larger range) and TIMESTAMP (UTC conversion, smaller range) based on whether automatic time‑zone handling and the 2038 limit suit your application, with Unix timestamps as a high‑performance alternative.
This article explores common pitfalls in Java date handling such as thread‑unsafe SimpleDateFormat and daylight‑saving issues, and presents robust solutions including ThreadLocal wrappers, Java 8 Date‑Time API, timezone‑aware calculations, caching strategies, and global interceptor designs to ensure safe, performant, and maintainable time processing.
This article presents fifty ready‑to‑use Python examples covering file and directory manipulation, data processing, network requests, date‑time utilities, and assorted handy tools, each accompanied by clear explanations and complete code snippets to help developers quickly apply common programming tasks.
This article presents 50 concise Python code snippets that demonstrate essential techniques for file and directory manipulation, data handling, web requests, date and time processing, and a variety of useful utilities, providing ready‑to‑use examples for developers of all levels.
This article walks through a real‑world Python time‑formatting bug, explains why a stray newline character breaks parsing, and provides a clear, step‑by‑step solution with screenshots to help developers quickly resolve similar issues.
This article demonstrates five pandas‑based methods for extracting unique hourly records from an Excel file, showing how to manipulate datetime columns, drop duplicates, and save the cleaned data, while comparing the strengths and pitfalls of each approach.
This article provides a comprehensive overview of Python's core date and time handling modules, including datetime, time, calendar, dateutil, and zoneinfo, with practical examples and installation instructions for advanced functionality.
This article explains how to retrieve a file’s last modification time in PHP using functions like filemtime(), stat(), and the DateTime class, and provides a practical example for detecting changes and notifying users.
This article explains MySQL's various numeric, date/time, and string data types, discusses their characteristics such as signed/unsigned integers, floating‑point precision, fixed‑point accuracy, and provides practical best‑practice recommendations for choosing optimal types in database design.
This article explains PHP's time() function, describing how it returns the current Unix timestamp, demonstrates basic usage, and provides multiple code examples for retrieving timestamps, comparing dates, and formatting the current date and time.
This guide presents ten Python date and time libraries—Arrow, Chronyk, dateutil, Delorean, Maya, Pendulum, PyTime, pytz, when.py, and moment—detailing typical scenarios, core features, and ready-to-run code snippets for creation, parsing, formatting, timezone conversion, and arithmetic.
This article explains PHP's versatile date() function, detailing its syntax, required format parameter, optional timestamp argument, and demonstrates numerous usage examples—including retrieving current date, time, individual components, and formatting specific timestamps—highlighting its importance for backend web development.
This article explains PHP's date() function, its syntax, required and optional parameters, and provides multiple code examples demonstrating how to retrieve and format current dates, times, and timestamps for various use cases in backend development.
This article examines PHP's DateTime class, analyzing its mutable design drawbacks, the benefits of the immutable DateTimeImmutable alternative, and offers practical guidelines and best‑practice strategies for developers to write safer, more maintainable date‑handling code.
Learn how to elegantly process Java 8 date parameters, register custom converters, conditionally enable controllers, apply unified API prefixes, perform service‑layer validation, and control asynchronous request timeouts in Spring Boot 3.2.5 using annotations, configuration files, and programmatic WebMvcConfigurer techniques.
This tutorial demonstrates how to use Python's datetime and calendar modules to obtain the current date and time, convert dates to timestamps, perform date arithmetic, format and parse dates, generate date ranges, compare dates, and display monthly calendars, with clear code examples for each operation.
This guide explains how to use the Linux date command to display, format, and manipulate dates and times, covering options such as –date, –file, –set, –u, –r, relative dates, and custom format strings, with practical code examples for each scenario.
This article provides practical code examples for using key Python standard library modules—including os, sys, json, datetime, re, math, collections, urllib, random, and logging—to perform common tasks such as file operations, system info, data parsing, date handling, pattern matching, calculations, data structures, web requests, random generation, and logging.
freezegun is a Python library that lets developers mock and freeze the current time, enabling precise control over time‑dependent code during unit testing, with examples covering basic usage, timezone handling, complex datetime objects, and dynamic time manipulation.
This article presents a collection of practical Python code snippets covering timestamp retrieval, date formatting, JSON correction, URL query parsing, file comment extraction, INI configuration reading, and project‑relative path resolution to help developers handle common tasks efficiently.
This article explains several Java date‑time pitfalls—including leap‑year calculations, differences between YYYY/yyyy and HH/hh patterns, SimpleDateFormat initialization, Calendar hour fields, integer overflow in date arithmetic, thread‑unsafe usage of SimpleDateFormat, and daylight‑saving‑time handling—providing code examples and best‑practice recommendations.
This article explains why pandas adds a time component when reading dates from Excel or CSV files and provides three practical methods—specifying column formats, using datetime.strptime, and setting a date parser for Excel—to keep dates unchanged while still enabling further datetime operations.
This article introduces several lesser‑known but highly practical Python standard‑library modules—including collections, datetime, random, itertools, csv, os, pickle, argparse, and unittest—explaining their core classes and functions with clear code examples and common application scenarios.
This article provides a thorough overview of Python's time‑related libraries—including the built‑in time and datetime modules, third‑party pytz, dateutil, and Arrow—explaining core concepts such as timestamps, time zones, daylight‑saving time, and ISO 8601 parsing with clear code examples and usage patterns.
This article explains the PHP date() function, covering its syntax, required and optional parameters, common format characters for year, month, day, hour, minute and second, additional textual options, usage for timestamp conversion, and timezone considerations, helping developers handle date and time tasks efficiently.
This article walks through the latest Java 21 additions—including enhanced String search methods, new Emoji utilities in Character, repeat() for StringBuilder and StringBuffer, updated Charset factories, named regex groups, SequencedCollection interfaces, localized DateTimeFormatter patterns, extended Math and BigInteger operations, and improved Thread and Future APIs—providing code examples and usage guidance.
This article provides a collection of Python examples that demonstrate how to convert lists and strings to JSON, format dates and timestamps, read files, generate QR codes and barcodes, compare lists and JSON data, retrieve class methods via reflection, and automatically delete large files based on size and time.
This article analyzes a puzzling OceanBase data‑type implicit conversion problem where UPDATE statements intermittently fail with SQL syntax errors while SELECT statements return unexpected results, explains the underlying conversion mechanisms, shows diagnostic queries and log excerpts, and provides practical recommendations to avoid such errors.
This article shows a step‑by‑step Python solution for finding the third last working day of any month, explaining the logic behind handling month‑end dates and weekend adjustments, and provides ready‑to‑run code for immediate use.
This article walks through converting a high‑precision timestamp like "2022-03-25 08:00:00.000000000" into a readable Chinese date format using Python's datetime module, offering simpler alternatives to cumbersome string‑splitting tricks.
This article introduces the Python dateutil library, showing how to install it, parse various date strings, perform date arithmetic with relativedelta, handle time zones, format dates, compute intervals, parse ISO strings, and generate recurring events through clear code examples.
This article provides a thorough walkthrough of Java 8's date‑time API, covering formatting patterns, obtaining current dates and times, extracting components, creating specific dates, comparing dates, handling periodic events, timezone offsets, timestamps, custom parsing, common pitfalls, and thread‑safety considerations, all illustrated with clear code examples.
This article demonstrates how to install and use the Carbon PHP extension to simplify date and time operations, covering retrieval of current, today, yesterday, tomorrow, parsing specific strings, timezone handling, adding and subtracting years, months, weeks, days, hours, minutes, seconds, and formatting dates in various styles.
This article demonstrates how to use Java 8’s java.time package to obtain the current date and time, extract components, create specific dates, compare dates, handle periodic dates, compute future and past dates, retrieve timestamps, check leap years, calculate differences, and format/parse date strings, with concrete code examples.
This article compares three common Java date‑time formatting approaches—SimpleDateFormat, Java 8’s DateTimeFormatter, and Apache Commons Lang3’s DateFormatUtils—examines thread‑safety issues, provides code examples, and offers conversion utilities between Date, LocalDate, and LocalDateTime for robust backend development.
This article presents 18 practical techniques for using Java 8’s new date‑time API, demonstrating how to obtain, manipulate, compare, format, and calculate dates and times with immutable, thread‑safe classes such as LocalDate, LocalTime, ZonedDateTime, and Instant, while providing full code examples for each use case.
This article explains how to parse intricate datetime strings in Python using the datetime module, presents multiple code solutions with full examples, and provides a reusable function to convert UTC timestamps to Beijing time, helping readers handle common time‑formatting challenges.
This article explores several Python techniques—including the time, datetime, and dateutil modules, as well as pure arithmetic and NumPy—to reliably transform a "HH:MM:SS" string into the total number of seconds, while addressing timezone and year‑offset nuances.
This tutorial demonstrates multiple pandas techniques—including datetime mapping, MonthBegin/MonthEnd offsets, floor operations, period conversion, and asfreq—to accurately retrieve the first and last day of a month for any given date, while highlighting common pitfalls and performance considerations.
This guide shows how to transform string‑typed date columns into proper datetime objects using pandas' pd.to_datetime, covering basic usage, key parameters, handling various formats, timestamps, and practical code examples for reliable data cleaning.
This article explains how to perform precise numeric operations, format numbers, convert between bases, handle complex numbers, work with infinities and NaN, use fractions, manipulate large arrays with NumPy, generate random data, and manage dates, times, and time zones in Python.
This article compares Java's legacy date handling in JDK7 with the modern java.time API introduced in JDK8, demonstrating how to create, format, and convert dates using LocalDate, LocalDateTime, DateTimeFormatter, and related methods, and provides a comprehensive table of useful LocalDate APIs.
This article walks through five pandas-based methods—and an optional openpyxl approach—to extract unique date‑hour entries from an Excel file, explaining each technique, its code, and the nuances of handling datetime rounding and duplicate removal.
This article explains how to globally handle LocalDate, LocalDateTime, and LocalTime parameters in Spring Boot 2.x by creating custom Converter beans, configuring Jackson's ObjectMapper, using @DateTimeFormat, ControllerAdvice, and understanding the underlying parameter resolution mechanisms to avoid common pitfalls such as lambda‑based converter registration failures.
This article provides a detailed tutorial on Python's time‑related classes and functions, covering Unix timestamps, conversion tools, and the practical use of the calendar, time, and datetime modules with examples of formatting, timezone conversion, and common time‑conversion tricks for everyday programming tasks.
This tutorial explains six Python techniques—including datetime.weekday(), datetime.isoweekday(), strftime(), calendar, pendulum, and pandas—to retrieve the weekday of any given date such as 2022‑02‑22, with code examples and usage tips for data analysis.
This article evaluates how MySQL handles time data stored as datetime, timestamp, and bigint by inserting half a million records and measuring query, grouping, and sorting speeds, concluding that bigint generally offers the best performance for time‑range operations.
A Java program that formats "1900-01-01 08:00:00" unexpectedly prints "1900-01-01 08:05:43" due to historic Shanghai timezone offsets, and the article walks through the bug, related OpenJDK issues, Stack Overflow cases, and how different TZDB releases affect the result.
The article explains a mysterious Java date‑formatting bug where parsing "1900-01-01 08:00:00" with SimpleDateFormat yields "1900-01-01 08:05:43", tracing the cause to historic Shanghai timezone offsets and changes in the IANA TZ database across JDK versions.
This article walks through a fan's question on converting a Chinese date string like '2021年9月28日' into the standard '2021/9/28' format, presenting three practical Python solutions—including direct replacement, split‑and‑join, and datetime parsing—so you can pick the most suitable method for bulk data processing.
This comprehensive guide walks you through Python’s time‑handling ecosystem, covering the low‑level time module, the richer datetime module, timezone utilities like pytz, advanced parsing with dateutil, and the user‑friendly Arrow library, complete with explanations, code snippets, and practical examples for formatting, conversion, and manipulation.
This article introduces Java 8's new date‑time API, explains why the old java.util.Date and SimpleDateFormat were problematic, and provides eleven practical code examples that demonstrate how to obtain the current date, extract year/month/day, create specific dates, compare dates, work with time zones, and format or parse date strings.
This article provides a detailed overview of Python's time‑handling ecosystem, covering fundamental concepts of seconds, GMT, UTC and leap seconds, the low‑level time module, high‑level datetime classes, timezone manipulation with pytz, flexible parsing with dateutil, and the user‑friendly Arrow library, complete with code examples and usage notes.
This article benchmarks MySQL's datetime, timestamp, and bigint columns by inserting 500,000 rows and measuring query, group‑by, and order‑by performance, concluding that bigint generally offers the best speed for time‑based operations while timestamp saves space for static timestamps.
This article introduces Python function fundamentals, shows how to define and call functions, demonstrates common time‑related functions from the time and datetime modules, and provides examples of calendar and random number utilities, all illustrated with clear code snippets and output screenshots.
This article explains the shortcomings of the legacy java.util.Date and Calendar classes, outlines the motivations behind creating a new date‑time API, and introduces Java 8's JSR‑310 solution with its comprehensive class hierarchy, range handling, chronology support, and fluent method design.
This article introduces Go's time package, explaining its core types such as Month, Weekday, Duration, Location, and Time, and demonstrates how to work with timers, tickers, and time parsing through clear examples and code snippets.
This article introduces Python functions, demonstrates how to define and call them, and explores essential time-related modules such as time, datetime, calendar, and random, providing clear code examples and output screenshots to help beginners grasp practical usage.
Java 8 adds powerful functional constructs—lambda expressions, method and constructor references, the Stream API, and Optional—plus a modern, thread‑safe date‑time library, and this tutorial explains their syntax, core interfaces, common operations, and practical backend examples to improve code readability and conciseness.
This tutorial shows how to use PHP's date and strtotime functions to retrieve the first and last day of the current month, extract the current year/month/day and total days in the month, obtain month boundaries via a custom function, and calculate the previous month's start and end dates.
The article explains PHP's mktime() function, detailing its syntax, parameter list, default behavior, return value, and provides a complete example showing how to generate a Unix timestamp for a specific date and time.
The PHP localtime() function returns the local date and time as an array, optionally associative, mirroring the C library function, and accepts an optional Unix timestamp parameter, with examples showing both numeric and associative array outputs.
This article introduces Java 8's modern date‑time API, explains why the old java.util.Date and SimpleDateFormat are problematic, and provides a series of concise, runnable examples that demonstrate how to obtain the current date, extract year/month/day, work with specific dates, compare dates, handle time zones, calculate periods, format and parse strings, and more.
This tutorial shows how to add query parameters to an API request using Python's requests library, retrieve JSON data about ISS passes over a location, extract timestamps, and convert them into readable dates.
This article explains the differences between naive and aware datetime objects, how Django sets the TZ environment variable, the behavior of datetime.now, timezone.now, and related Python functions, and provides practical guidance for storing and converting timestamps in Django applications.
This tutorial walks through Python's time and datetime modules, covering timestamps, sleep, local time, formatting, parsing, arithmetic, and the dateutil library for flexible month and year adjustments, with code examples and visual output to illustrate each concept.
The article examines the shortcomings of Java’s pre‑Java 8 date‑time classes—Date, Calendar, and SimpleDateFormat—highlighting their thread‑unsafe, confusing APIs and time‑zone pitfalls, then demonstrates how Java 8’s new date‑time API (LocalDateTime, ZonedDateTime, ZoneId, DateTimeFormatter) provides clear, thread‑safe handling and proper internationalization.
This article introduces Java 8's new date‑time API, explains why it replaces the mutable java.util.Date and non‑thread‑safe SimpleDateFormat, and provides a series of clear code examples demonstrating how to obtain current dates, manipulate specific dates, compare dates, handle time zones, work with periods, and format dates using the modern java.time classes.
This article provides a step‑by‑step guide on using the Python Arrow library to obtain UTC and local times, format dates, shift time values, parse arbitrary timestamps, and convert Arrow objects to native datetime, date, and time types, complete with code examples and result screenshots.
A game server developer copied a flawed Java function to calculate offline days, which mis‑computed the difference across year boundaries, leading to thousands of erroneous reward emails on 2020‑01‑01, and the issue was resolved by switching to the Java 8 date‑time API.
This article provides a comprehensive overview of Python's three core time modules—datetime, time, and calendar—explaining their design, key concepts like epoch, UTC, DST, and demonstrating essential APIs for retrieving, converting, and manipulating dates and times.
The article explains why Python developers often swap the arguments of datetime.strptime, analyzes the naming and semantics of strptime and strftime, demonstrates correct usage with code examples, and discusses the source‑to‑destination pattern and related special cases such as regex and string methods.
This article examines common date and time storage options in databases—string, DateTime, Timestamp, and Unix timestamp—highlighting their characteristics, timezone handling, performance implications, and best-use scenarios, with Java code examples and migration tips.
This article provides a concise reference of frequently used PHP functions for handling arrays, strings, dates and times, databases, files, and directories, highlighting each function’s purpose, typical parameters, and return values to aid developers in efficient backend programming.
This tutorial explains how to retrieve the current timestamp, format specific dates, convert between strings and datetime objects, perform time indexing with pandas, and execute time arithmetic and offsets in Python using datetime, pandas, and dateutil libraries.
This article explains the design of Java's time system, covering the epoch start, offset representation, timezone handling, historical changes, and the modern Java 8 date‑time API with practical code examples and usage guidelines.
This tutorial introduces Java 8's new date‑time API, explains why the old java.util.Date and SimpleDateFormat were problematic, and demonstrates immutable, thread‑safe classes like LocalDate, LocalTime, LocalDateTime, ZoneId, YearMonth, and Instant through clear, runnable code snippets.
This article provides a comprehensive overview of Python's time‑related modules—datetime, time, and calendar—explaining their design, key concepts like epoch, UTC, DST, and practical APIs for obtaining, converting, and manipulating dates and times.
This tutorial demonstrates how Java 8's new immutable, thread‑safe date‑time API (java.time) can be used to obtain the current date, extract year/month/day, create specific dates, compare dates, handle time zones, format and parse strings, and perform common date‑time calculations with clear code examples.
This tutorial walks through loading order data into pandas and SQL, then demonstrates how to retrieve current dates, extract date components, convert between readable dates and Unix timestamps, transform between 10‑digit and 8‑digit date formats, and perform date arithmetic using pandas, MySQL, and Hive.
This article explains why the legacy Date and SimpleDateFormat classes are problematic, introduces Java 8's immutable LocalDate, LocalTime, LocalDateTime and Instant classes, demonstrates thread‑safe creation, formatting, parsing, modification and calculation, and shows practical SpringBoot integration examples.
This article explains MySQL date‑time data types, compares DATETIME and TIMESTAMP, shows how to map them to Java types, provides SQL examples, and demonstrates several methods for timezone conversion between MySQL and Java applications.
This article explains the physical and philosophical notions of time, the challenges of representing time in computing, and provides a comprehensive guide to Java's date‑time APIs—including System.currentTimeMillis, System.nanoTime, java.util.Date, java.sql.Timestamp, Calendar, SimpleDateFormat, and the modern Java 8 classes such as Instant, LocalDate/Time, ZonedDateTime, and DateTimeFormatter—while highlighting common pitfalls and best practices.
This article introduces Java 8's new date‑time API, explains the shortcomings of the old java.util.Date classes, and provides practical examples for using Instant, LocalDate, LocalTime, LocalDateTime, ZonedDateTime, Duration, Period and DateTimeFormatter in real projects.
This article explains how to use Python's time and datetime modules to calculate workdays between two dates, determine week counts, and retrieve dates offset by a given number of days or months, providing reusable utility scripts with clear code examples.
This article provides a comprehensive overview of Python’s three core time-handling modules—time, datetime, and calendar—explaining key concepts such as epoch, UTC/GMT, time zones, DST, and demonstrating how to retrieve, format, and convert dates and times using their APIs.
