Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
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 | WMS Tech | SuiteCommerce Advanced
----
- NetSuite Admin Corner | 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!
- Expand your NetSuite knowledge by joining this month's Ask A Guru Live about Suitebuilder . RSVP on this event now!
Tagged:
0