var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I need to use the ADD_MONTHS function on a date field with the following format "YYYYMMDD", however, I get erroneous results when using ADD_MONTHS with this format. Does this function only work with the default date format, "DD-MON-YY"????
erroneous results, or a syntax error?
what's the datatype of your date field?
nothing obvious suggests itself
can you show the query, the original date, and the result?
ADD_MONTHS works on any DATE() format fields. You had to be doing something wrong in your query. Either check the syntax of the query one more time, or post it here to tell you what is wrong.
Hope that helps,
OCP - DBA
Latest Oracle DBA forums | Oracle DBA Resources | Oracle Usenet Groups
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors