query
| От | Chandan_Kumaraiah |
|---|---|
| Тема | query |
| Дата | |
| Msg-id | 2EB549AAAFEA264FA926269A5BD5E9EB146577@certsrv.satyam.com обсуждение исходный текст |
| Ответы |
Re: query
|
| Список | pgsql-sql |
<div class="Section1"><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>
В списке pgsql-sql по дате отправления: