Hello. current_date - 1 is the solution.
2009/10/14 Shruthi A <shruthi.i...@gmail.com> > 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