I have created a custom object with a time varying attribute that has "Number" as the data units and the conversion unit is set to Hours. While inputting and viewing the content on a daily timescale we are seeing the vale as input. But while querying it on the database we are seeing the same stored differently. As an example we input 8 for each day on the timescale fir a certain week. While querying the database we are seeing a 5 digit number. Is the database storing the user input in a different time format than hours. If so what formula should I use to read the database correctly.
Kind regards
Ashwin
The database value is usually in seconds. Its the app that converts that to the relevant "display unit", be it hours, days etc. So if you are looking at the database value, you also need to apply the same.
As David mentions, All stock TSV data is stored in seconds.
Therefore, to get hours you divide by 3600. (SLICE/3600) = HOURS