<div>
Just replace datediff with month_between function in Oracle and getdate with sysdate<br />
<br />
dateadd with add_months <br />
<br />
goto this site for examples:<br />
<br />
<a href="http://www.techonthenet.com/oracle/functions/index.php" rel="ugc">http://www.techonthenet.com/oracle/functions/index.php</a>
</div>


Just replace datediff with month_between function in Oracle and getdate with sysdate

dateadd with add_months

goto this site for examples:

http://www.techonthenet.com/oracle/functions/index.php [http://www.techonthenet.com/oracle/functions/index.php]

<div>
months_between returns date differences in months, but the datediff examples above are in days.<br />
<br />
just use standard arithmetic in Oracle
</div>


months_between returns date differences in months, but the datediff examples above are in days.

just use standard arithmetic in Oracle

<div>
<div class="content wysiwyg-content">
Hai !<br />
&nbsp; &nbsp; &nbsp; &nbsp; Can someone assist me to convert sybase code to oracle<br />
<br />
1. datediff(dd, dateadd(dy,-1,getDate()), dateadd(dy,14,ShipDate) ) &lt;&nbsp;0<br />
2. datediff(dd, getdate(), dateadd(dd,14,ShipDate) )=0<br />
3.datediff(dd,ReceiptDate,<wbr />ShipDate) <br />

</div>
</div>


Hai !
        Can someone assist me to convert sybase code to oracle

1. datediff(dd, dateadd(dy,-1,getDate()), dateadd(dy,14,ShipDate) ) < 0
2. datediff(dd, getdate(), dateadd(dd,14,ShipDate) )=0
3.datediff(dd,ReceiptDate,ShipDate) 


convert from sybase to oracle

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.