Choose Category
SELECT 'input date' - EXTRACT(DAY FROM 'input date') + 1;
SELECT '2012-06-06' - EXTRACT(DAY FROM '2012-06-06') + 1;