Monday, July 12, 2010

Get the last day of the current month

This query runs only in SQLite.
SELECT date('now','start of month','+1 month','-1 day');

No comments:

Post a Comment