LAST_DAY function in postgres

Question

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)

Here's a similar question: http://stackoverflow.com/questions/8944721/how-do-i-determine-the-last-day-of-the-previous-month-using-postgresql — vyegorov, Oct 27 '14 at 11:31

score 38 · Answer 1 · answered Jan 09 '13 at 06:10

Well, 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 Query

SELECT (date_trunc('MONTH', now()) + INTERVAL '1 MONTH - 1 day')::date;

plsql Function

        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.

score 1 · Answer 2 · edited May 19 '15 at 11:44

1

create or replace funCtion last_day(fromdt anyelement)
returns date as
$BODY$
  SELECT (date_trunc('MONTH', cast(fromdt as date)) + INTERVAL '1 MONTH - 1 day')::date;
$BODY$
  LANGUAGE sql VOLATILE
  COST 100;
  ALTER FUNCTION last_day(anyelement)
    OWNER TO postgres;

edited May 19 '15 at 11:44

Gonzalo Quero

3,303
18
23

answered May 19 '15 at 11:21

Abi naga Balan

21
1

postgres does not have last_day function we need to create user defined function – Abi naga Balan May 19 '15 at 11:23

LAST_DAY function in postgres

2 Answers2

Select Query

plsql Function

Linked