Conversion Function

Syntax

BI_DATEFORMAT(date, format)

Description

• date: the date to be converted.

• format: the format to be converted. The supported formats are as follows:

  yyyy: year

  MM: month

  dd: day

  hh: time

  mi: points

  ss: seconds

Description

Formats the date and outputs the text.

Output data type

String

Examples

BI_DATEFORMAT(2020-09-29, 'yyyyMMdd') = '20200929'

Syntax

BI_TODATE(date_string, format)

Description

• date_string: the string to be converted to the date type.

• format: the format of the date to be converted. The supported formats are as follows:

  yyyy: year

  MM: month

  dd: day

  hh: time

  mi: points

  ss: seconds

Description

Parses a string <date_string> in the <format> format and converts it to the date type.

Output data type

Date

Examples

BI_TODATE('2020-09-29', 'yyyy-MM-dd') = 2020-09-29

Syntax

BI_TODOUBLE(expression)

Description

expression: the text or value to be converted.

Description

Converts text or numeric values into floating-point numbers.

Output data type

N/A

Examples

BI_TODOUBLE('123.21') = 123.21

BI_TODOUBLE(3) = 3.0

Syntax

BI_TOINT(expression)

Description

expression: the text or value to be converted.

Description

Converts a text or number to an integer. If a decimal part exists, it is discarded.

Output data type

N/A

Examples

BI_TOINT('123.9') = 123

Syntax

BI_TOSTR(expression)

Description

expression: the value of the line to be added.

Description

Converts a numeric value into a string.

Output data type

String

Examples

BI_TOSTR(123) = '123'