Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Milliseconds shown in report although format is hh:mm:ss
Migrateduser
<p>Hi,</p><p> </p><p>I have a report with a table that shows this value from a postgres server:</p><p> </p><p>...</p><p>, (max(enddate) + ( intervals * '1 minute'::interval )) - now() as until_schedule</p><p>...</p><p> </p><p>When displaying this value in the table it is shown as 00:01:48.950568 for example. although I have set the date/time format for that data field to hh:mm:ss and would expect 00:01:48</p><p> </p><p>Is there a specific reason for this behaviour and how can I resolve it?</p><p>Thanks for any hint!</p><p> </p><p>Max</p>
Find more posts tagged with
Comments
There are no comments yet