database function Archives - Helical Insight

To_DateTime Database Function Usage in Helical Insight

In this blog, we will learn how to convert value to DATETIME from text/date/dateTime/time column in Helical Insight. Below you can see we are having a column in format “YYYY:MM:DD HH:MM:SS”. Click on column. Click on more, a user will get two options i.e., Quick and Advanced Click on “Advanced” in this you will see

database, database function, time database functions, to-datetime database

Share with

LTRIM Database Function Usage in Helical Insight

In this blog, we will learn how to remove all space characters from the left-side of a string from text column in Helical Insight. Below you can see we are having a column in text. If we want to remove all space characters from the left-side of a string. Click on column. Click on more,

database, database function, Itrim

Share with

NumericToString Database Function Usage in Helical Insight

In this blog we will learn how to convert the number, date, dateTime, time to string from date/dateTime/text column in Helical Insight. If we want to convert the number, date, dateTime, time to string. Click on Travel Cost column. Click on more, user will get two options i.e., Quick and Advanced Click on “Advanced” in

database function, helical insight, open source business intelligence

Share with

MOD Database Function Usage in Helical Insight

In this blog we will learn how to display the remainder of a number divided by another number from numeric column in Helical Insight. If we want to display the remainder of a number divided by another number .Click on Travel Cost column. Click on more, user will get two options i.e., Quick and Advanced

database function, helical insight, open source business intelligence

Share with

Format Database Function Usage in Helical Insight

In this blog we will learn how to numeric/decimal values formatted to comma separated numbers from numeric column in Helical Insight. If we want decimal value formatted to comma separated numbers. Click on Travel Cost column. Click on more, user will get two options i.e., Quick and Advanced Click on “Advanced” in this you will

database function, helical insight, numeric database, open source business intelligence