<div class="Section1"><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:
12.0pt"> </span></font><p class="MsoNormal"><b><font face="Tahoma" size="2"><span style="font-size:10.0pt;
font-family:Tahoma;font-weight:bold">Hi,</span></font></b><p class="MsoNormal"><b><font face="Tahoma" size="2"><span
style="font-size:10.0pt;
font-family:Tahoma;font-weight:bold"> </span></font></b><p class="MsoNormal"><b><font face="Tahoma" size="2"><span
style="font-size:10.0pt;
font-family:Tahoma;font-weight:bold">In oracle we write sysdate-1</span></font></b><p class="MsoNormal"><b><font
face="Tahoma"size="2"><span style="font-size:10.0pt;
font-family:Tahoma;font-weight:bold">For example,we write a query (select * from table1 where
created_date>=sysdate-1).Whatsits equivalent in postgre?</span></font></b><p class="MsoNormal"><b><font
face="Tahoma"size="2"><span style="font-size:10.0pt;
font-family:Tahoma;font-weight:bold"> </span></font></b><p class="MsoNormal"><b><font face="Tahoma" size="2"><span
style="font-size:10.0pt;
font-family:Tahoma;font-weight:bold">Chandan</span></font></b><p class="MsoNormal"><b><font face="Tahoma"
size="2"><spanstyle="font-size:10.0pt;
font-family:Tahoma;font-weight:bold"> </span></font></b></div>