What is the most straightforward way to pad empty dates in sql results (on either mysql or perl end)?

What is the most straightforward way to pad empty dates in sql results (on either mysql or perl end)?

mysql perl calendar datediff

mysql

SQL Infinite Calendar Pattern

php mysql codeigniter calendar

mysql

Exposing calendar as an iCal with subscribe option in PHP

php mysql calendar webdav webcal

mysql