This guide explains MySQL’s most useful date and time functions—including CURDATE(), NOW(), DATE_FORMAT(), DATEDIFF(), DATE_ADD(), DATE_SUB(), and DATE()—with clear syntax examples and sample results, helping developers manipulate temporal data efficiently in their databases.
Explore a collection of essential PHP built‑in functions—from string distance with levenshtein and phonetic matching via metaphone, to date calculations, DNS queries, array merging, email sending, dynamic extension loading, file globbing, and process forking—complete with clear code examples and expected outputs.
This article explains the PHP time() function, its syntax, usage examples, and important considerations such as timestamp units, server time versus client time, and related date functions, helping developers retrieve and work with the current UNIX timestamp in PHP scripts.
This article explains MySQL's date and time manipulation functions—including addtime, adddate, date_add, subtime, subdate, and date_sub—showing their syntax, usage with numeric and INTERVAL arguments, and providing example queries for adding or subtracting seconds, minutes, days, weeks, months, and years.
This article introduces several SQL date‑time functions—including TO_TIMESTAMP, LOCALTIMESTAMP, NOW, CURRENT_TIMESTAMP, DATE_FORMAT, and UNIX_TIMESTAMP—explaining their syntax, parameters, behavior, and providing example queries with expected results for each function.
This tutorial walks through creating a fully functional PHP calendar class that generates an HTML table, handles navigation between months and years, and integrates customizable CSS styling, providing complete source code and step‑by‑step explanations for developers.
The JDToJulian function converts a given Julian Day count into a readable Julian calendar date formatted as month/day/year, accepting an integer Julian Day number as input and returning the corresponding date string.
