Re: How to get the previous date? - Mailing list pgsql-sql

From Dmitriy Igrishin
Subject Re: How to get the previous date?
Date
Msg-id b4399d110910140243q408a3e50y46dd7da936bdfe57@mail.gmail.com
Whole thread Raw
In response to How to get the previous date?  (Shruthi A <shruthi.iisc@gmail.com>)
List pgsql-sql
Hello.<br /><br />current_date - 1 is the solution.<br /><br /><div class="gmail_quote">2009/10/14 Shruthi A <span
dir="ltr"><<ahref="mailto:shruthi.iisc@gmail.com">shruthi.iisc@gmail.com</a>></span><br /><blockquote
class="gmail_quote"style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left:
1ex;"><spanstyle="font-family: courier new,monospace;">Hi, <br /><br /> I'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,
simplyreturns the previous date? I tried <br /><br /> mydate - 1 <br /><br /> but this doesnt work. <br /><br />
Thanks,<br /><font color="#888888"> Shruthi</font></span></blockquote></div><br /> 

pgsql-sql by date:

Previous
From: Shruthi A
Date:
Subject: How to get the previous date?
Next
From: "ramasubramanian"
Date:
Subject: Re: How to get the previous date?