Inside Out

How duration field values are stored

If the field stores a duration value, it will store the duration as the result of a calculation: minutes x 10. For example, 10 hours would be stored as 10 hours x 60 minutes x 10, or 6000. A work value is stored as minutes x 1000. So 2 hours worked would store as 2 hours x 60 minutes x 1000, or 120,000.

In the Project OLE DB Provider, the Number data type is used to represent these types of data. In the Project Server database, the data types Decimal, Integer, Smallint, and Tinyint are used to represent these types of data.

In the Project Server database, the data types Decimal, Float, Integer, Smallint, and Tinyint are used.

Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook


Post a comment