1. 

   JimTer, Member

   I want to display 65 as 1:05 because 65 stands for minutes.
   Is there a mydbr-command?
   And is it possible to aggregate on the column that displays 1:05?
2. 

   myDBR Team, Key Master

   In what context do you display the time?

   --
   myDBR Team
3. 

   JimTer, Member

   Context...
   Its just a column in a report
4. 

   myDBR Team, Key Master

   myDBR will by default handle time datatype automatically.

   If your minutes data is in a integer column you can convert it to time by using database functions. In MySQL use sec_to_time( myminutes * 60 ), in SQL Server use convert-function.

   When a column is a time column, myDBR handles aggregate calculation automatically.

   --
   myDBR Team

Reply

You must log in to post.