Hi,
if didn't find this function on
http://www.postgresql.org/docs/7.3/interactive/functions-datetime.html,
You have to write own function
testdb=> create or replace function last_day(date) returns date as 'select
cast(date_trunc(''month'', $1) + ''1 month''::interval as date) - 1'
language sql;
CREATE FUNCTION
testdb=> select last_day(current_date);
last_day
------------
2003-09-30
(1 řádka)
Bye
Pavel
On Tue, 2 Sep 2003, Amin Schoeib wrote:
> Hi,
> I would like to know if there is a Function in Postgres
> Like the LAST_DAY Function in Oracle??
> In Oracle you can use the function the get the last day of a month.
>
> Thanxx
>
> Schoeib
>
>
> 4Tek Gesellschaft für angewandte Informationstechnologien mbH
> Schoeib Amin
> Tel. +49 (0) 69 697688-132
> Fax. +49 (0) 69 697688-111
> http://www.4tek.de
>
>
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
