<div>
You could use the overloaded arithmetic in PostgreSQL to achieve the same result. For example if you wanted to add one day to a given date you would do something similar to the code below.<br />
<br />
Read <a href="http://www.postgresql.org/docs/8.2/interactive/functions-datetime.html" rel="ugc">http://www.postgresql.org/docs/8.2/interactive/functions-datetime.html</a>&nbsp;for more info.<br />
<br />

<pre><code id="code-8889">date '2007-12-06' + interval '1 day'
</code></pre>
</div>


You could use the overloaded arithmetic in PostgreSQL to achieve the same result. For example if you wanted to add one day to a given date you would do something similar to the code below.

Read http://www.postgresql.org/docs/8.2/interactive/functions-datetime.html [http://www.postgresql.org/docs/8.2/interactive/functions-datetime.html] for more info.



date '2007-12-06' + interval '1 day'


<div>
Thanks, what if I had a column called term that held &nbsp;the number of months I want to add? <br />
Would it be:<br />
&lt;date filed&gt; + interval '&lt;term&gt; months' &nbsp;<br />
<br />
<br />

</div>


Thanks, what if I had a column called term that held  the number of months I want to add?
Would it be:
<date filed> + interval '<term> months'  




<div>
<div class="content wysiwyg-content">
I am looking for the syntax for the date function that works like dateadd in sql server that I can use in PostgreSQL.<br />
<br />

</div>
</div>


I am looking for the syntax for the date function that works like dateadd in sql server that I can use in PostgreSQL.



What is the equivalent date function in postgreSQL for add_months or DateAdd

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.