This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Anyone explain why these are the same?
TO_DATE({trandate}) + {integer field type}
TO_DATE({trandate} + {integer field type})

In Netsuite, integer field type just naturally can be added onto a date?

<https://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm#i1006312|Datetime and Interval Arithmetic and Comparisons>

<@U5TF1GQ20>
&gt; Oracle interprets `NUMBER` constants in datetime and interval expressions as number of days.

in this situation is 'DATE' and 'datetime' same thing?

read the entire page so you can tell me the difference between a date and datetime in sql

Nvm someone actually answered the question on stackoverflow