Is there any function(s) in postgres equivalent to Oracle function LAST_DAY().
I need to get last day in postgres (including month and year)
See Question&Answers more detail:osIs there any function(s) in postgres equivalent to Oracle function LAST_DAY().
I need to get last day in postgres (including month and year)
See Question&Answers more detail:osWell, In postgres, it seems there's no such function equivalent to LAST_DAY()
available in oracle.
If you need to, you can have your own in the following ways as a
SELECT (date_trunc('MONTH', now()) + INTERVAL '1 MONTH - 1 day')::date;
CREATE OR REPLACE FUNCTION last_day(date)
RETURNS date AS
$$
SELECT (date_trunc('MONTH', $1) + INTERVAL '1 MONTH - 1 day')::date;
$$ LANGUAGE 'sql'
IMMUTABLE STRICT;
Hope this helps.