Hour format in reports (for duration)?

(4 posts) (2 voices)

Tags:

  1. 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. 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.