Like what you see? Have a play with our trial version.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Data type conversion

Related type

Description

Text to Numeric

Text

To convert a text or string into numeric values. However, this will only work if the data values are numbers.

Text to SQL Date

Text

 To To convert text to SQL date.

Text to SQL Timestamp

Text

To convert text to SQL timestamp. 

Java timestamp

Numeric

To convert numeric value to a Java timestamp.

Numeric Divide

Numeric

To divide the values with a specified denominator.
Numeric to SQL DateNumericTo convert numeric data to SQL date.
Numeric to SQL TimestampNumericTo convert numeric data to SQL timestamp.
Numeric to TextNumericTo convert numeric data to text.

Note: Most of these are simply selections and don't require further steps.The process involved in some of these data type conversions is fairly simple, and do not require additional steps. 

Anchor
numericdivide
numericdivide

Numeric Divide

...