Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 0B95F632AD3
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 14 Oct 2009 06:40:49 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 47635-10 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 14 Oct 2009 09:40:41 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-iw0-f186.google.com (mail-iw0-f186.google.com
	[209.85.223.186])
	by mail.postgresql.org (Postfix) with ESMTP id 248A7634601
	for <pgsql-sql@postgresql.org>; Wed, 14 Oct 2009 06:40:41 -0300 (ADT)
Received: by iwn16 with SMTP id 16so5209475iwn.29
	for <pgsql-sql@postgresql.org>; Wed, 14 Oct 2009 02:40:40 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:date:message-id:subject
	:from:to:content-type;
	bh=ahX470dqajHS/4SXUUcD+BV1Kyrwktl3h511Q4eRF3k=;
	b=Br/KgR/DiuFdKE492647EXtUsszDMXtMnFGtolpIJ8Yw6pOvsVafjbZ7jzm6RhX61a
	xZz3j6G9y+cZ7mLA9OmgwRdX5eJsvli4hDp0S5tx9DuM3TEaXlbsXiFbT/NBqjglNKUP
	WiyISUYBAy+YAECAS73f/l+R9w1/4P12twrHc=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=ryhf9NBxpfNAUwelAPxDw45L5j26/OJqMGSBK6Wn+KDqJS4IR3QCB7w3qr/WicuRvD
	wH/aMKrHSnUsfjsgGHSUMgjzjkU5NaPyqlk1zI3KH5vIBRLZJLQ0rMKv+K6xgY7j5euV
	P4InWZDZq3YSOHx/2HKw3wNipqhVPjlKeC1K8=
MIME-Version: 1.0
Received: by 10.231.123.216 with SMTP id q24mr3530371ibr.43.1255513240075;
	Wed, 14 Oct 2009 02:40:40 -0700 (PDT)
Date: Wed, 14 Oct 2009 15:10:40 +0530
Message-ID: <6caee9520910140240u13daba93ua20637642727776e@mail.gmail.com>
Subject: How to get the previous date?
From: Shruthi A <shruthi.iisc@gmail.com>
To: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=0016e64698e4af821f0475e1f43d
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.739 tagged_above=-10 required=5
	tests=BAYES_20=-0.74, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200910/55
X-Sequence-Number: 33254

--0016e64698e4af821f0475e1f43d
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I'm using Enterprise DB PostgresPlus version 8.3.
Is there is a simple function or command like previous_date(mydate) which
when passed a particular date, simply returns the previous date? I tried

mydate - 1

but this doesnt work.

Thanks,
Shruthi

--0016e64698e4af821f0475e1f43d
Content-Type: text/html; charset=ISO-8859-1

<span style="font-family: courier new,monospace;" class="postbody">Hi,
<br> 
<br> I&#39;m using Enterprise DB PostgresPlus version 8.3.
<br> Is there is a simple function or command like
previous_date(mydate) which when passed a particular date, simply
returns the previous date? I tried <br> 
<br> mydate - 1
<br> 
<br>                 but this doesnt work.  
<br> 
<br> Thanks,
<br> Shruthi</span>

--0016e64698e4af821f0475e1f43d--