Tagged articles
unix timestamp
17 articles · Page 1 of 1
This guide explains what a UNIX timestamp is, shows how to retrieve the current timestamp with PHP's time() function, and provides practical examples for calculating time intervals and sorting timestamps using simple PHP code.
Backenddate calculationtime function
0 likes · 3 min read

Learn how PHP’s powerful strtotime() function transforms human‑readable date strings into UNIX timestamps, covering its syntax, common formats—including relative dates, absolute dates, time intervals, and special keywords—plus usage tips, limitations, and advanced parameters for flexible date handling.
BackendDate ParsingPHP
0 likes · 4 min read

The article explains the upcoming 2038 Y2K38 Unix time overflow, why Debian is proactively converting its entire system to 64‑bit time stamps, the technical challenges involved, and how legacy 32‑bit hardware and software will be affected.
64-bitDebianY2K38
0 likes · 7 min read

Learn how PHP’s strtotime() function transforms human‑readable date strings into UNIX timestamps, covering its syntax, parameters, and common formats such as relative dates, absolute dates, time intervals, and special keywords, while noting its parsing limits and extra options.
Date Parsingstrtotimeunix timestamp
0 likes · 4 min read

Learn how PHP’s built-in time() function returns the current Unix timestamp, how to use it without parameters, and see practical code examples for displaying timestamps, comparing dates with strtotime(), and formatting dates with date() and timezone settings.
PHPdate handlingtime
0 likes · 4 min read

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.
DATETIMEMySQLPostgreSQL
0 likes · 11 min read

This article explores how time is represented in computers, explains historic bugs like the Y2K and the upcoming 2038 issue, clarifies GMT/UTC, time zones and daylight saving, and compares 32‑bit and 64‑bit timestamps, Java long handling, and architectural differences that affect time calculations.
2038 problem32-bit vs 64-bitJava long
0 likes · 12 min read

This article explains why storing dates as strings is problematic, compares MySQL's DATETIME and TIMESTAMP types—including their storage size, range, and timezone behavior—provides practical SQL examples, discusses numeric Unix timestamps, and offers guidance on selecting the most suitable type for different scenarios.
MySQLperformancetimestamp
0 likes · 12 min read

This article explains PHP's time() function, describing how it returns the current Unix timestamp, demonstrates basic usage with code examples, shows how to compare dates and format the timestamp, and provides practical snippets for common time‑related tasks in backend development.
BackendPHPdate handling
0 likes · 4 min read

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.
DATETIMEphp-tutorialtime function
0 likes · 5 min read

This article explains how to obtain the current UNIX timestamp in PHP using the built‑in time() function, demonstrates code examples for displaying the timestamp, calculating yesterday’s date, and sorting an array of timestamps, and discusses common scenarios where timestamps are useful.
PHPdate calculationtime function
0 likes · 4 min read

This article explains PHP's built‑in time() function, describing its role in returning the current Unix timestamp, demonstrating usage without parameters, and providing multiple code examples—including basic timestamp output, date comparison with strtotime(), and formatted date/time retrieval after setting the timezone.
date handlingphp-tutorialtime function
0 likes · 4 min read

This article explains the PHP function unixtojd, which converts a given Unix timestamp into its corresponding Julian Day number, returning the current day's count when no timestamp is supplied, and details its parameter and return value.
BackendDate ConversionJulian Day
0 likes · 1 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 article explains why many systems display the date 1970‑01‑01, demonstrates how to reproduce it with Java code, and traces the historical development of the Unix timestamp from its 1971 inception to the modern 1970 epoch standard.
Epoch TimeJava Dateprogramming fundamentals
0 likes · 7 min read

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

This article compares common database date‑time storage options—string fields, DATETIME, TIMESTAMP, and Unix timestamps—explaining their formats, range limits, timezone handling, performance implications, and provides Java code examples and SQL conversion tips to help developers select the most suitable approach for their systems.
databasesdate-timetimestamp
0 likes · 6 min read
