Tagged articles
Date
33 articles · Page 1 of 1
Many developers write messy SQL or generate slow reports because they don’t know built‑in functions; this guide compiles the most frequently used string, date, math, and conversion functions—complete with ready‑to‑copy examples—to handle 99% of everyday data‑processing scenarios.
ConversionDateMath
0 likes · 4 min read

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.
BackendDATETIMEDate
0 likes · 9 min read

This article explains the shortcomings of java.util.Date—its misleading name, mutability, poor API design, thread‑unsafe formatting, and time‑zone ambiguities—provides concrete code examples of these issues, and demonstrates modern, immutable replacements from the java.time package such as Instant, LocalDate, LocalDateTime, ZonedDateTime and Period for safer, clearer date‑time handling in Java applications.
Datejava.timespring-boot
0 likes · 13 min read

JavaScript’s native Date object is fraught with inconsistencies—ambiguous parsing, mutable instances, zero‑based months, and no built‑in formatting—leading to bugs across browsers and time zones, so developers should adopt immutable third‑party libraries like Day.js or the upcoming Temporal API for reliable date handling.
DateDay.jsJavaScript
0 likes · 8 min read

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.
DATETIMEDateDuration
0 likes · 15 min read

This article explains how to use PHP's filemtime function to obtain a file's last modification timestamp, demonstrates single‑file and multiple‑file examples with code, and shows how to format the timestamp using the date function.
BackendDatefile-modification
0 likes · 4 min read

This article explains how to use PHP's filemtime function to obtain a file's last modification timestamp, demonstrates converting it to a readable date with date(), and provides code examples for retrieving timestamps for a single file and multiple files.
DatePHPfile-modification
0 likes · 4 min read

Learn how to correctly handle time zones in JavaScript by storing dates in UTC, using the IANA database, detecting daylight saving time, and leveraging built‑in Intl APIs or libraries like Luxon, with practical code examples and best‑practice guidelines.
DateLuxondst
0 likes · 17 min read

This guide explains how to automatically generate and embed a software version string during compilation for embedded projects, using a header file updated by a Bash script that leverages the Linux date command and Git metadata to simplify version tracking and debugging.
DateGitVersioning
0 likes · 7 min read

This article explains the PHP time() function, describing how it returns the current Unix timestamp, how to use it without parameters, and provides multiple code examples for retrieving timestamps, comparing dates, and formatting the current date and time.
DatePHPbackend development
0 likes · 4 min read

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.
BackendDATETIMEDate
0 likes · 4 min read

The article explains the design flaws of java.util.Date, why it should be replaced, and provides a step‑by‑step guide with code examples for migrating to the modern java.time classes such as Instant, LocalDateTime, LocalDate, and ZonedDateTime in Java backend projects.
APIDatejava.time
0 likes · 10 min read

The article explains the design flaws of java.util.Date, such as mutability, misleading naming, and timezone issues, and provides a step‑by‑step guide to replace it and related APIs with java.time classes like Instant, LocalDateTime, and ZonedDateTime, including code examples.
APIDatejava.time
0 likes · 13 min read

This article explains how to use PHP's timestamp functions—including time(), strtotime(), date(), and mktime()—to obtain current timestamps, convert strings to timestamps, format dates, handle time zones, and perform relative time calculations with practical code examples.
Datestrtotimetime
0 likes · 5 min read


ByteFEJan 9, 2023 · Frontend Development
This article examines why native JavaScript Date falls short for time handling, explains time measurement standards and time zones, and compares four major date libraries—MomentJS, DayJS, date-fns, and native Date—highlighting their advantages, drawbacks, and appropriate usage scenarios.
DateDayjsJavaScript
0 likes · 12 min read

An online promotion that should end at 23:59:59 displayed as finished early due to an 8‑hour discrepancy, traced through HTTP packet capture, DB fields, and Java’s Date handling, revealing that Date objects use the local timezone while timestamps are based on UTC, causing mismatched calculations.
DateDebuggingJava
0 likes · 8 min read

This article lists ten frequent mistakes when using Java's date and time APIs—such as misusing Calendar fields, wrong format patterns, thread‑unsafe SimpleDateFormat, and daylight‑saving quirks—and provides clear corrected examples and best‑practice solutions.
DateSimpleDateFormatcalendar
0 likes · 12 min read

The article examines how to design cross‑database date and time storage by comparing MySQL, Oracle, and SQL Server date‑time types, discussing their formats, ranges, storage sizes, and trade‑offs, and proposes practical solutions such as using timestamps, custom conversion functions, and ORM considerations.
DateOracleSQL Server
0 likes · 7 min read

This article explains why JavaScript's Date constructor treats ISO‑8601 date‑only strings as UTC but interprets other date formats using the local time zone, detailing V8's parsing logic and showing example outputs in Node.js.
DateISO8601Node.js
0 likes · 4 min read

The article explains PHP's cal_days_in_month function, detailing its purpose, parameters (calendar, month, year), return value, and provides a complete example showing how to retrieve and display the number of days in a specific month of a given year.
BackendDateFunction
0 likes · 2 min read

The jdmonthname function in PHP returns the name of a month based on a given Julian day number and a specified calendar mode, detailing its string return type, required integer parameters, and usage for different calendar systems.
BackendDateFunction
0 likes · 1 min read

The JDDayOfWeek PHP function returns the day of the week for a given Julian day number, offering numeric or English string results based on an optional mode parameter, making it useful for date calculations in backend development.
BackendDateFunction
0 likes · 2 min read

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.
BackendDATETIMEDate
0 likes · 3 min read

This article explains the history of global time standards, how computers represent time with Unix timestamps and the 2038 problem, details ISO 8601 and RFC 2822 formats, and provides practical JavaScript Date usage examples along with comparisons of popular date‑handling libraries such as Moment.js, Dayjs, and Miment.
DateDayjsJavaScript
0 likes · 22 min read

This guide explains how PHP's date() function formats local timestamps into custom strings, details its optional parameters, return behavior, and provides multiple practical code examples demonstrating common format patterns and timezone handling.
DateFormattingPHP
0 likes · 3 min read

This guide explains four practical Linux commands—stat, stat with a custom format, date with the -r option, and ls -lt—to display a file’s last modification timestamp, and also shows how to retrieve remote file dates using the httpie tool.
Datecommand-linefile-modification
0 likes · 6 min read

This tutorial demonstrates how to use PHP variables and the date() function to automatically compute a student's age based on their birthdate, handling current date retrieval, birthday checks, and adjusting the age calculation accordingly.
BackendDatePHP
0 likes · 3 min read

This article explains how to construct SQL INSERT statements for string, numeric, date, and boolean fields, demonstrates variable concatenation for dynamic values, and provides a comprehensive example that combines multiple data types into a single query.
DateINSERTSQL
0 likes · 5 min read

This guide explains how to perform time addition, subtraction, and difference calculations in shell scripts by converting dates to timestamps, manipulating seconds, and converting results back to readable formats, complete with practical examples and essential Bash arithmetic operators.
Datebashshell
0 likes · 4 min read

This guide explains how to perform time addition and calculate time differences in Bash by converting dates to Unix timestamps, adjusting with arithmetic, and converting results back to readable format, including examples and shell arithmetic operator notes.
Datebashshell
0 likes · 4 min read

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.
DATETIMEDateWorkday
0 likes · 9 min read

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.
DateJavaScriptfrontend
0 likes · 12 min read

This article explains the legacy java.util.Date class, its limited useful constructors and methods, the more flexible java.util.Calendar API, how to format and parse dates with DateFormat and SimpleDateFormat, and best practices for storing timestamps in databases using long values.
DateSimpleDateFormatcalendar
0 likes · 9 min read
