Shridhar Daithankar wrote:
> On 2 Sep 2003 at 15:08, Amin Schoeib wrote:
> > 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.
>
> While this is not a direct answer to questio
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 s
On 2 Sep 2003 at 15:08, Amin Schoeib wrote:
> 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.
While this is not a direct answer to question..
It made me think. I am sure lot of
Title: LAST_DAY Function in Postgres
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
S
