In this blog we will learn how to Displays time value from a given hour, minute and seconds from any date / date time column in Helical Insight.
-
- If we want to Displays time value from a given hour, minute and seconds .click on Travel Date column.
-
- Click on more,user will get two options i.e., Quick and Advanced
-
- Go to “Advanced” in the functions box and in this you will see a function called “maketime”. Double click on that function and then drag down the minute ,hours and seconds column in the selected maketime function/user can enter the minute,hours,seconds in the box at the bottom.click on “save” Button
-
- Click on “Generate” report. You will see the desired output as below.
Note: These functions are specific to the database and may / may not appear based on the kind of database that you are connecting to. Please refer to below blog to add more database functions for your specific use case.