Date Functions Articles

Page 1 of 1 (4 articles)

3/6/2025 • EN

The Biggest Problems with SQL Date Functions and How to Solve Them

Common issues with SQL date functions and practical solutions for developers and DBAs to avoid errors and improve query performance.

data integrity database Date Functions Query Optimization sql

Bjoern Peters

12/10/2024 • EN

Index Usage For EXTRACT(YEAR FROM …), YEAR(…) etc.

Explains how different database systems rewrite date/time range queries to enable efficient index usage for functions like EXTRACT(YEAR FROM ...).

Database Optimization Date Functions Index Usage Query Rewriting SQL Performance

Markus Winand

1/27/2023 • EN

My top-10 favourite functions in PHP

A developer shares their top 10 favorite built-in PHP functions, highlighting useful and surprising capabilities of the language.

asynchronous programming Date Functions php Process Forking String Functions

Brent

6/8/2017 • EN

Working with time in Postgres

A guide to using PostgreSQL's built-in time and date functions, including intervals and date_trunc, for efficient time-based data queries and reporting.

Date Functions Date Math Interval postgresql time

Craig Kerstiens

Date Functions Articles

The Biggest Problems with SQL Date Functions and How to Solve Them

Index Usage For EXTRACT(YEAR FROM …), YEAR(…) etc.

My top-10 favourite functions in PHP

Working with time in Postgres

Select Language