1. 

   simonmd, Member

   Hi all,

   I have a SQL view that has a column with values in the SQL TIME format. They are actually durations, that show up well in various SQL clients. However, when I create a procedure for that view in MyDBR, the value shows up as "7:00 PM". How can I get it to show as eg: "45:23:18" ?
   I tried creating a column style. If I put "%s" as the printf argument, the output is: "45,:23,:18" , and if I put "%d", the output is "45" (as a number, which is cool because it remains sortable at least).

   Any ideas as to how I might do this?

   Thanks,

   Simon

   BTW - Great Product! Just what we needed.
2. 

   myDBR Team, Key Master

   We will be releasing a minor update later this week which will include improvements on the UI elements (mainly for the mobile side). We'll improve the time formatting on that one. You can then distinct actual time values from durations.

   --
   myDBR Team
3. 

   simonmd, Member

   Excellent! thanks!
4. 

   myDBR Team, Key Master

   myDBR 1.4.2 now includes the ability to turn times into duration. Duration column is always formatted as (H:M:S) and aggregate functions (sum, avg. etc) can be applied into it.

   To use it simply apply a column format (%s) to a time column or use aggregate functions for the column.
   --
   myDBR Team

Reply

You must log in to post.