Previous month function

From: "Matt Arnilo S(dot) Baluyos" <mbaluyos(at)sni(dot)ph>
To: pgsql-novice(at)postgresql(dot)org
Subject: Previous month function
Date: 2004-11-17 09:12:15
Message-ID: 200411171712.15439.mbaluyos@sni.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


hello everyone,

is there already a built-in function that returns the previous month from the
current timestamp? (and includes functionality to turn back one year if
current month is january)

i don't want to reinvent the wheel but if there's none then i guess i would
just have to make one from scratch.

--
Matt Arnilo S. Baluyos
Research and Software Development
System Net International, Inc. - Philippines

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Dzial Techniczny 2004-11-17 11:07:21 [OT] apache auth with postgres?
Previous Message Rajan Bhide 2004-11-17 08:02:42 Syntax error in DROP CONSTRAINT