Advanced Search

Return to Snippet

Revision: 4052
at October 19, 2007 04:27 by arunpjohny
Initial Code 
CREATE OR REPLACE FUNCTION LastDateOfMonth(date) RETURNS date AS '
SELECT CAST(date_trunc(''month'', $1) + interval ''1 month''
- interval ''1 day'' as date);
' LANGUAGE sql;
Initial URL 









Initial Description














Initial Title





Get the last date a given month









Initial Tags














Initial Language





SQL