function to find last day of month

From: "Jennifer Lee" <jlee(at)scri(dot)sari(dot)ac(dot)uk>
To: <pgsql-general(at)postgresql(dot)org>
Subject: function to find last day of month
Date: 2003-12-05 11:33:11
Message-ID: BE57D4C018CC2642AF256E2FDDA909573693F5@sims.scri.sari.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Does anyone happen to have a function, prefereably in pl/pgsql, which
given the month and year will return the last day in that month?

Thanks,
Jennifer

*****************************************************************
DISCLAIMER:

This email is from the Scottish Crop Research Institute, but the views expressed by the sender are not necessarily the views of SCRI and its subsidiaries. This email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee.
If you are not the intended recipient you are requested to preserve this confidentiality and you must not use, disclose, copy, print or rely on this e-mail in any way. Please notify mail(at)scri(dot)sari(dot)ac(dot)uk quoting the name of the sender and delete the email from your system.

Although SCRI has taken reasonable precautions to ensure no viruses are present in this email, neither the Institute nor the sender accepts any responsibility for any viruses, and it is your responsibility to scan the email and the attachments (if any).

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2003-12-05 12:10:41 OpenFTS-perl-0.35 released
Previous Message CSN 2003-12-05 11:03:58 update time zone in timestamps