Discussions
SuiteWorld is the largest annual gathering of the NetSuite community! It will be held in Las Vegas on October 6-9, 2025. Our customers and partners look forward to SuiteWorld every year as a place to hear the latest from NetSuite, get hands-on learning, and connect with each other. Register now!
NSC | Mastering Time Arithmetic in SQL using NetSuite2.com data source
Performing time arithmetic in SQL involves adding or subtracting a fraction of a day to a given date or timestamp. The logic is simple: to add a certain amount of time, you add a fraction of a day, and to subtract time, you subtract the corresponding fraction.
For instance, suppose you want to add or subtract 60 minutes from a given date. Since there are 1440 minutes in a day (24 hours * 60 minutes), you would add or subtract 60/1440 (or 1/24) of a day.
Here's a breakdown of the process:
To add time: You add the fraction of a day to the date.
To subtract time: You subtract the fraction of a day from the date.
Richard James Uri | SuiteCloud and WMS Tech
----
- New to NetSuite
- Explore the NSC Webinars Category
- Join our poll and share your ideas! We want to know what you think. Don't forget to comment and make your voice heard!