Conversions (Dataflow Library Distribution Project 7.0.3-11 API)

java.lang.Object
- com.pervasive.datarush.functions.Conversions

```
public class Conversions
extends Object
```
Provides implementations of common type conversion functions. These functions are for conversions which would not normally be permitted by the token type system as they are either possibly "lossy" (such as type narrowing) or ambiguous (such as string formatting).

See Also:

ScalarValuedFunction, DeriveFields

Method Summary

All Methods Static Methods Concrete Methods
Modifier and Type	Method and Description
`static ScalarValuedFunction`	`asBoolean(ScalarValuedFunction expr, int truth, int falsity)` Convert an int typed field into a boolean type.
`static ScalarValuedFunction`	`asBoolean(String field)` Convert an int typed field into a boolean type.
`static ScalarValuedFunction`	`asBoolean(String field, int truth, int falsity)` Convert an int typed field into a boolean type.
`static ScalarValuedFunction`	`asDate(ScalarValuedFunction expr)` Convert a timestamp expression result into a date field.
`static ScalarValuedFunction`	`asDate(String field)` Convert a timestamp typed field into a date field.
`static ScalarValuedFunction`	`asDouble(ScalarValuedFunction expr)` Convert a numeric typed expression into a double type.
`static ScalarValuedFunction`	`asDouble(String field)` Convert a numeric typed field into a double type.
`static ScalarValuedFunction`	`asFloat(ScalarValuedFunction expr)` Convert a numeric typed expression into a float type.
`static ScalarValuedFunction`	`asFloat(String field)` Convert a numeric typed field into a float type.
`static ScalarValuedFunction`	`asInt(ScalarValuedFunction expr)` Convert a numeric typed expression into an integer type.
`static ScalarValuedFunction`	`asInt(String field)` Convert a numeric typed field into an integer type.
`static ScalarValuedFunction`	`asLong(ScalarValuedFunction expr)` Convert a numeric typed expression into a long type.
`static ScalarValuedFunction`	`asLong(String field)` Convert a numeric typed field into a long type.
`static ScalarValuedFunction`	`asMoney(ScalarValuedFunction expr)` Convert a numeric typed expression into a money type.
`static ScalarValuedFunction`	`asMoney(String field)` Convert a numeric typed field into a money type.
`static ScalarValuedFunction`	`asNumeric(ScalarValuedFunction expr)` Convert a numeric typed expression into a numeric type.
`static ScalarValuedFunction`	`asNumeric(String field)` Convert a numeric typed field into a numeric type.
`static ScalarValuedFunction`	`asTime(ScalarValuedFunction expr)` Convert a timestamp expression result into a time field.
`static ScalarValuedFunction`	`asTime(String field)` Convert a timestamp typed field into a time field.
`static ScalarValuedFunction`	`toBinary(ScalarValuedFunction expr)` Convert a string typed expression into a binary type.
`static ScalarValuedFunction`	`toBinary(String fieldName)` Convert a string typed field into a binary type.
`static ScalarValuedFunction`	`toBoolean(ScalarValuedFunction expr, String truth, String falsity)` Convert a string typed expression into a boolean type.
`static ScalarValuedFunction`	`toBoolean(ScalarValuedFunction expr, TruthValues mapping)` Convert a string typed expression into a boolean type.
`static ScalarValuedFunction`	`toBoolean(String field, String truth, String falsity)` Convert a string typed field into a boolean type.
`static ScalarValuedFunction`	`toBoolean(String field, TruthValues mapping)` Convert a string typed field into a boolean type.
`static ScalarValuedFunction`	`toChar(ScalarValuedFunction expr)` Convert a string typed expression into a char type.
`static ScalarValuedFunction`	`toChar(String fieldName)` Convert a string typed field into a char type.
`static ScalarValuedFunction`	`toDate(ScalarValuedFunction expr)` Convert a string typed expression into a date type.
`static ScalarValuedFunction`	`toDate(ScalarValuedFunction expr, DateTimeFormatting format)` Convert a string typed expression into a date type using the given format.
`static ScalarValuedFunction`	`toDate(String field)` Convert a string typed field into a date type.
`static ScalarValuedFunction`	`toDate(String field, DateTimeFormatting format)` Convert a string typed field into a date type using the given format.
`static ScalarValuedFunction`	`toDate(String field, String format)` Convert a string typed field into a date type using the given format.
`static ScalarValuedFunction`	`toDouble(ScalarValuedFunction expr)` Convert a string typed expression into a double type.
`static ScalarValuedFunction`	`toDouble(ScalarValuedFunction expr, NumberFormat format)` Convert a string typed expression into a double type using the given format.
`static ScalarValuedFunction`	`toDouble(String field)` Convert a string typed field into a double type.
`static ScalarValuedFunction`	`toDouble(String field, NumberFormat format)` Convert a string typed field into a double type using the given format.
`static ScalarValuedFunction`	`toDouble(String field, String format)` Convert a string typed field into a double type using the given format.
`static ScalarValuedFunction`	`toFloat(ScalarValuedFunction expr)` Convert a string typed expression into a float type.
`static ScalarValuedFunction`	`toFloat(ScalarValuedFunction expr, NumberFormat format)` Convert a string typed expression into a float type using the given format.
`static ScalarValuedFunction`	`toFloat(String field)` Convert a string typed field into a float type.
`static ScalarValuedFunction`	`toFloat(String field, NumberFormat format)` Convert a string typed field into a float type using the given format.
`static ScalarValuedFunction`	`toFloat(String field, String format)` Convert a string typed field into a float type using the given format.
`static ScalarValuedFunction`	`toInt(ScalarValuedFunction expr)` Convert a string typed expression into a integer type.
`static ScalarValuedFunction`	`toInt(ScalarValuedFunction expr, NumberFormat format)` Convert a string typed expression into a integer type using the given format.
`static ScalarValuedFunction`	`toInt(String field)` Convert a string typed field into a integer type.
`static ScalarValuedFunction`	`toInt(String field, NumberFormat format)` Convert a string typed field into a integer type using the given format.
`static ScalarValuedFunction`	`toInt(String field, String format)` Convert a string typed field into a integer type using the given format.
`static ScalarValuedFunction`	`toLong(ScalarValuedFunction expr)` Convert a string typed expression into a long type.
`static ScalarValuedFunction`	`toLong(ScalarValuedFunction expr, NumberFormat format)` Convert a string typed expression into a long type using the given format.
`static ScalarValuedFunction`	`toLong(String field)` Convert a string typed field into a long type.
`static ScalarValuedFunction`	`toLong(String field, NumberFormat format)` Convert a string typed field into a long type using the given format.
`static ScalarValuedFunction`	`toLong(String field, String format)` Convert a string typed field into a long type using the given format.
`static ScalarValuedFunction`	`toMoney(ScalarValuedFunction expr)` Convert a string typed expression into a money type.
`static ScalarValuedFunction`	`toMoney(ScalarValuedFunction expr, NumberFormat format)` Convert a string typed expression into a money type using the given format.
`static ScalarValuedFunction`	`toMoney(String field)` Convert a string typed field into a money type.
`static ScalarValuedFunction`	`toMoney(String field, NumberFormat format)` Convert a string typed field into a money type using the given format.
`static ScalarValuedFunction`	`toMoney(String field, String format)` Convert a string typed field into a money type using the given format.
`static ScalarValuedFunction`	`toNumeric(ScalarValuedFunction expr)` Convert a string typed expression into a numeric type.
`static ScalarValuedFunction`	`toNumeric(ScalarValuedFunction expr, NumberFormat format)` Convert a string typed expression into a numeric type using the given format.
`static ScalarValuedFunction`	`toNumeric(String field)` Convert a string typed field into a numeric type.
`static ScalarValuedFunction`	`toNumeric(String field, NumberFormat format)` Convert a string typed field into a numeric type using the given format.
`static ScalarValuedFunction`	`toNumeric(String field, String format)` Convert a string typed field into a numeric type using the given format.
`static ScalarValuedFunction`	`toString(ScalarValuedFunction expr)` Convert the value of an expression into a string value.
`static ScalarValuedFunction`	`toString(String field)` Convert a scalar type field into a string value.
`static ScalarValuedFunction`	`toText(ScalarValuedFunction expr, Format formatter)` Convert the value of an expression into text using the given format.
`static ScalarValuedFunction`	`toText(ScalarValuedFunction expr, String format)` Convert the value of an expression into text using the given format.
`static ScalarValuedFunction`	`toText(String field, Format formatter)` Convert a scalar type field into text using the given format.
`static ScalarValuedFunction`	`toText(String field, String format)` Convert a scalar type field into text using the given format.
`static ScalarValuedFunction`	`toTime(ScalarValuedFunction expr)` Convert a string typed expression into a time type.
`static ScalarValuedFunction`	`toTime(ScalarValuedFunction expr, DateTimeFormatting format)` Convert a string typed expression into a time type using the given format.
`static ScalarValuedFunction`	`toTime(String field)` Convert a string typed field into a time type.
`static ScalarValuedFunction`	`toTime(String field, DateTimeFormatting format)` Convert a string typed field into a time type using the given format.
`static ScalarValuedFunction`	`toTime(String field, String format)` Convert a string typed field into a time type using the given format.
`static ScalarValuedFunction`	`toTimestamp(ScalarValuedFunction expr)` Convert a string typed expression into a timestamp type.
`static ScalarValuedFunction`	`toTimestamp(ScalarValuedFunction expr, DateTimeFormatting format)` Convert a string typed expression into a timestamp type using the given format.
`static ScalarValuedFunction`	`toTimestamp(String field)` Convert a string typed field into a timestamp type.
`static ScalarValuedFunction`	`toTimestamp(String field, DateTimeFormatting format)` Convert a string typed field into a timestamp type using the given format.
`static ScalarValuedFunction`	`toTimestamp(String field, String format)` Convert a string typed field into a timestamp type using the given format.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Method Detail
  - asBoolean
```
public static ScalarValuedFunction asBoolean(String field)
```
    Convert an int typed field into a boolean type. Unmapped values will be set to null.
    
    Parameters:
    
    field - a field whose type is an int
    
    Returns:
    
    the function that provides the conversion
  - asBoolean
```
public static ScalarValuedFunction asBoolean(String field,
                                             int truth,
                                             int falsity)
```
    Convert an int typed field into a boolean type. Unmapped values will be set to null.
    
    Parameters:
    
    field - a field whose type is an int
    
    truth - int representing the value of true
    
    falsity - int representing the value of false
    
    Returns:
    
    the function that provides the conversion
  - asBoolean
```
public static ScalarValuedFunction asBoolean(ScalarValuedFunction expr,
                                             int truth,
                                             int falsity)
```
    Convert an int typed field into a boolean type. Unmapped values will be set to null.
    
    Parameters:
    
    expr - a function expression whose return type is an int
    
    truth - int representing the value of true
    
    falsity - int representing the value of false
    
    Returns:
    
    the function that provides the conversion
  - asFloat
```
public static ScalarValuedFunction asFloat(String field)
```
    Convert a numeric typed field into a float type. Note that precision may be lost during the conversion.
    
    Parameters:
    
    field - a field whose type is a number
    
    Returns:
    
    the function that provides the conversion
  - asFloat
```
public static ScalarValuedFunction asFloat(ScalarValuedFunction expr)
```
    Convert a numeric typed expression into a float type. Note that precision may be lost during the conversion.
    
    Parameters:
    
    expr - a function expression whose return type is a number
    
    Returns:
    
    the function that provides the conversion
  - asDouble
```
public static ScalarValuedFunction asDouble(String field)
```
    Convert a numeric typed field into a double type. Note that precision may be lost during the conversion.
    
    Parameters:
    
    field - a field whose type is a number
    
    Returns:
    
    the function that provides the conversion
  - asDouble
```
public static ScalarValuedFunction asDouble(ScalarValuedFunction expr)
```
    Convert a numeric typed expression into a double type. Note that precision may be lost during the conversion.
    
    Parameters:
    
    expr - a function expression whose return type is a number
    
    Returns:
    
    the function that provides the conversion
  - asInt
```
public static ScalarValuedFunction asInt(String field)
```
    Convert a numeric typed field into an integer type. Note that precision may be lost during the conversion.
    
    Parameters:
    
    field - a field whose type is a number
    
    Returns:
    
    the function that provides the conversion
  - asInt
```
public static ScalarValuedFunction asInt(ScalarValuedFunction expr)
```
    Convert a numeric typed expression into an integer type. Note that precision may be lost during the conversion.
    
    Parameters:
    
    expr - a function expression whose return type is a number
    
    Returns:
    
    the function that provides the conversion
  - asLong
```
public static ScalarValuedFunction asLong(String field)
```
    Convert a numeric typed field into a long type. Note that precision may be lost during the conversion.
    
    Parameters:
    
    field - a field whose type is a number
    
    Returns:
    
    the function that provides the conversion
  - asLong
```
public static ScalarValuedFunction asLong(ScalarValuedFunction expr)
```
    Convert a numeric typed expression into a long type. Note that precision may be lost during the conversion.
    
    Parameters:
    
    expr - a function expression whose return type is a number
    
    Returns:
    
    the function that provides the conversion
  - asMoney
```
public static ScalarValuedFunction asMoney(String field)
```
    Convert a numeric typed field into a money type. Note that precision may be lost during the conversion.
    
    Parameters:
    
    field - a field whose type is a number
    
    Returns:
    
    the function that provides the conversion
  - asMoney
```
public static ScalarValuedFunction asMoney(ScalarValuedFunction expr)
```
    Convert a numeric typed expression into a money type. Note that precision may be lost during the conversion.
    
    Parameters:
    
    expr - a function expression whose return type is a number
    
    Returns:
    
    the function that provides the conversion
  - asNumeric
```
public static ScalarValuedFunction asNumeric(String field)
```
    Convert a numeric typed field into a numeric type. The numeric type is typically backed by a BigDecimal object.
    
    Parameters:
    
    field - a field whose type is a number
    
    Returns:
    
    the function that provides the conversion
  - asTime
```
public static ScalarValuedFunction asTime(String field)
```
    Convert a timestamp typed field into a time field. This down casting essentially drops the date portion of the timestamp field leaving only the time portion. The timestamp is interpreted using the timezone offset associated with it.
    
    Parameters:
    
    field - a field whose type is timestamp
    
    Returns:
    
    the function that provides the conversion
  - asTime
```
public static ScalarValuedFunction asTime(ScalarValuedFunction expr)
```
    Convert a timestamp expression result into a time field. This down casting essentially drops the date portion of the timestamp field leaving only the time portion. The timestamp is interpreted using the timezone offset associated with it.
    
    Parameters:
    
    expr - a function expression whose return type is timestamp
    
    Returns:
    
    the function that provides the conversion
  - asNumeric
```
public static ScalarValuedFunction asNumeric(ScalarValuedFunction expr)
```
    Convert a numeric typed expression into a numeric type. The numeric type is typically backed by a BigDecimal object.
    
    Parameters:
    
    expr - a function expression whose return type is a number
    
    Returns:
    
    the function that provides the conversion
  - asDate
```
public static ScalarValuedFunction asDate(String field)
```
    Convert a timestamp typed field into a date field. This down casting essentially drops the time portion of the timestamp field leaving only the date portion.
    
    Parameters:
    
    field - a field whose type is timestamp
    
    Returns:
    
    the function that provides the conversion
  - asDate
```
public static ScalarValuedFunction asDate(ScalarValuedFunction expr)
```
    Convert a timestamp expression result into a date field. This down casting essentially drops the time portion of the timestamp field leaving only the date portion.
    
    Parameters:
    
    expr - a function expression whose return type is timestamp
    
    Returns:
    
    the function that provides the conversion
  - toBinary
```
public static ScalarValuedFunction toBinary(String fieldName)
```
    Convert a string typed field into a binary type.
    
    Parameters:
    
    field - a field whose type is string
    
    Returns:
    
    the function that provides the conversion
  - toBinary
```
public static ScalarValuedFunction toBinary(ScalarValuedFunction expr)
```
    Convert a string typed expression into a binary type.
    
    Parameters:
    
    expr - an expression whose type is string
    
    Returns:
    
    the function that provides the conversion
  - toChar
```
public static ScalarValuedFunction toChar(String fieldName)
```
    Convert a string typed field into a char type.
    
    Parameters:
    
    field - a field whose type is string
    
    Returns:
    
    the function that provides the conversion
  - toChar
```
public static ScalarValuedFunction toChar(ScalarValuedFunction expr)
```
    Convert a string typed expression into a char type.
    
    Parameters:
    
    expr - an expression whose type is string
    
    Returns:
    
    the function that provides the conversion
  - toDouble
```
public static ScalarValuedFunction toDouble(String field)
```
    Convert a string typed field into a double type.
    
    Parameters:
    
    field - a field whose type is string
    
    Returns:
    
    the function that provides the conversion
  - toDouble
```
public static ScalarValuedFunction toDouble(ScalarValuedFunction expr)
```
    Convert a string typed expression into a double type.
    
    Parameters:
    
    expr - a function expression whose return type is string
    
    Returns:
    
    the function that provides the conversion
  - toDouble
```
public static ScalarValuedFunction toDouble(String field,
                                            String format)
```
    Convert a string typed field into a double type using the given format.
    
    Parameters:
    
    field - a field whose type is string
    
    format - format specification to use to convert strings to doubles
    
    Returns:
    
    the function that provides the conversion
  - toDouble
```
public static ScalarValuedFunction toDouble(String field,
                                            NumberFormat format)
```
    Convert a string typed field into a double type using the given format.
    
    Parameters:
    
    field - a field whose type is string
    
    format - formatter instance to use to convert strings to doubles
    
    Returns:
    
    the function that provides the conversion
  - toDouble
```
public static ScalarValuedFunction toDouble(ScalarValuedFunction expr,
                                            NumberFormat format)
```
    Convert a string typed expression into a double type using the given format.
    
    Parameters:
    
    expr - a function expression whose return type is string
    
    format - formatter instance to use to convert strings to doubles
    
    Returns:
    
    the function that provides the conversion
  - toFloat
```
public static ScalarValuedFunction toFloat(String field)
```
    Convert a string typed field into a float type.
    
    Parameters:
    
    field - a field whose type is string
    
    Returns:
    
    the function that provides the conversion
  - toFloat
```
public static ScalarValuedFunction toFloat(ScalarValuedFunction expr)
```
    Convert a string typed expression into a float type.
    
    Parameters:
    
    expr - a function expression whose return type is string
    
    Returns:
    
    the function that provides the conversion
  - toFloat
```
public static ScalarValuedFunction toFloat(String field,
                                           String format)
```
    Convert a string typed field into a float type using the given format.
    
    Parameters:
    
    field - a field whose type is string
    
    format - format specification to use to convert string to floats
    
    Returns:
    
    the function that provides the conversion
  - toFloat
```
public static ScalarValuedFunction toFloat(String field,
                                           NumberFormat format)
```
    Convert a string typed field into a float type using the given format.
    
    Parameters:
    
    field - a field whose type is string
    
    format - formatter instance to use to convert strings to floats
    
    Returns:
    
    the function that provides the conversion
  - toFloat
```
public static ScalarValuedFunction toFloat(ScalarValuedFunction expr,
                                           NumberFormat format)
```
    Convert a string typed expression into a float type using the given format.
    
    Parameters:
    
    expr - a function expression whose return type is string
    
    format - formatter instance to use to convert strings to floats
    
    Returns:
    
    the function that provides the conversion
  - toInt
```
public static ScalarValuedFunction toInt(String field)
```
    Convert a string typed field into a integer type.
    
    Parameters:
    
    field - a field whose type is string
    
    Returns:
    
    the function that provides the conversion
  - toInt
```
public static ScalarValuedFunction toInt(ScalarValuedFunction expr)
```
    Convert a string typed expression into a integer type.
    
    Parameters:
    
    expr - a function expression whose return type is string
    
    Returns:
    
    the function that provides the conversion
  - toInt
```
public static ScalarValuedFunction toInt(String field,
                                         String format)
```
    Convert a string typed field into a integer type using the given format.
    
    Parameters:
    
    field - a field whose type is string
    
    format - format specification to use to convert strings to integers
    
    Returns:
    
    the function that provides the conversion
  - toInt
```
public static ScalarValuedFunction toInt(String field,
                                         NumberFormat format)
```
    Convert a string typed field into a integer type using the given format.
    
    Parameters:
    
    field - a field whose type is string
    
    format - formatter instance to use to convert strings to integers
    
    Returns:
    
    the function that provides the conversion
  - toInt
```
public static ScalarValuedFunction toInt(ScalarValuedFunction expr,
                                         NumberFormat format)
```
    Convert a string typed expression into a integer type using the given format.
    
    Parameters:
    
    expr - a function expression whose return type is string
    
    format - formatter instance to use to convert strings to integers
    
    Returns:
    
    the function that provides the conversion
  - toLong
```
public static ScalarValuedFunction toLong(String field)
```
    Convert a string typed field into a long type.
    
    Parameters:
    
    field - a field whose type is string
    
    Returns:
    
    the function that provides the conversion
  - toLong
```
public static ScalarValuedFunction toLong(ScalarValuedFunction expr)
```
    Convert a string typed expression into a long type.
    
    Parameters:
    
    expr - a function expression whose return type is string
    
    Returns:
    
    the function that provides the conversion
  - toLong
```
public static ScalarValuedFunction toLong(String field,
                                          String format)
```
    Convert a string typed field into a long type using the given format.
    
    Parameters:
    
    field - a field whose type is string
    
    format - format specification to use to convert strings to longs
    
    Returns:
    
    the function that provides the conversion
  - toLong
```
public static ScalarValuedFunction toLong(String field,
                                          NumberFormat format)
```
    Convert a string typed field into a long type using the given format.
    
    Parameters:
    
    field - a field whose type is string
    
    format - formatter instance to use to convert strings to longs
    
    Returns:
    
    the function that provides the conversion
  - toLong
```
public static ScalarValuedFunction toLong(ScalarValuedFunction expr,
                                          NumberFormat format)
```
    Convert a string typed expression into a long type using the given format.
    
    Parameters:
    
    expr - a function expression whose return type is string
    
    format - formatter instance to use to convert strings to longs
    
    Returns:
    
    the function that provides the conversion
  - toMoney
```
public static ScalarValuedFunction toMoney(String field)
```
    Convert a string typed field into a money type.
    
    Parameters:
    
    field - a field whose type is string
    
    Returns:
    
    the function that provides the conversion
  - toMoney
```
public static ScalarValuedFunction toMoney(ScalarValuedFunction expr)
```
    Convert a string typed expression into a money type.
    
    Parameters:
    
    expr - a function expression whose return type is string
    
    Returns:
    
    the function that provides the conversion
  - toMoney
```
public static ScalarValuedFunction toMoney(String field,
                                           String format)
```
    Convert a string typed field into a money type using the given format.
    
    Parameters:
    
    field - a field whose type is string
    
    format - format specification to use to convert strings to money
    
    Returns:
    
    the function that provides the conversion
  - toMoney
```
public static ScalarValuedFunction toMoney(String field,
                                           NumberFormat format)
```
    Convert a string typed field into a money type using the given format.
    
    Parameters:
    
    field - a field whose type is string
    
    format - formatter instance to use to convert strings to money
    
    Returns:
    
    the function that provides the conversion
  - toMoney
```
public static ScalarValuedFunction toMoney(ScalarValuedFunction expr,
                                           NumberFormat format)
```
    Convert a string typed expression into a money type using the given format.
    
    Parameters:
    
    expr - a function expression whose return type is string
    
    format - formatter instance to use to convert strings to money
    
    Returns:
    
    the function that provides the conversion
  - toNumeric
```
public static ScalarValuedFunction toNumeric(String field)
```
    Convert a string typed field into a numeric type.
    
    Parameters:
    
    field - a field whose type is string
    
    Returns:
    
    the function that provides the conversion
  - toNumeric
```
public static ScalarValuedFunction toNumeric(ScalarValuedFunction expr)
```
    Convert a string typed expression into a numeric type.
    
    Parameters:
    
    expr - a function expression whose return type is string
    
    Returns:
    
    the function that provides the conversion
  - toNumeric
```
public static ScalarValuedFunction toNumeric(String field,
                                             String format)
```
    Convert a string typed field into a numeric type using the given format.
    
    Parameters:
    
    field - a field whose type is string
    
    format - format specification to use to convert strings to numerics
    
    Returns:
    
    the function that provides the conversion
  - toNumeric
```
public static ScalarValuedFunction toNumeric(String field,
                                             NumberFormat format)
```
    Convert a string typed field into a numeric type using the given format.
    
    Parameters:
    
    field - a field whose type is string
    
    format - formatter instance to use to convert strings to numeric
    
    Returns:
    
    the function that provides the conversion
  - toNumeric
```
public static ScalarValuedFunction toNumeric(ScalarValuedFunction expr,
                                             NumberFormat format)
```
    Convert a string typed expression into a numeric type using the given format.
    
    Parameters:
    
    expr - a function expression whose return type is string
    
    format - formatter instance to use to convert strings to numeric
    
    Returns:
    
    the function that provides the conversion
  - toBoolean
```
public static ScalarValuedFunction toBoolean(String field,
                                             String truth,
                                             String falsity)
```
    Convert a string typed field into a boolean type.
    
    Parameters:
    
    field - a field whose type is string
    
    truth - text representing the value of true
    
    falsity - text representing the value of false
    
    Returns:
    
    the function that provides the conversion
  - toBoolean
```
public static ScalarValuedFunction toBoolean(ScalarValuedFunction expr,
                                             String truth,
                                             String falsity)
```
    Convert a string typed expression into a boolean type.
    
    Parameters:
    
    expr - a function expression whose return type is string
    
    truth - text representing the value of true
    
    falsity - text representing the value of false
    
    Returns:
    
    the function that provides the conversion
  - toBoolean
```
public static ScalarValuedFunction toBoolean(String field,
                                             TruthValues mapping)
```
    Convert a string typed field into a boolean type.
    
    Parameters:
    
    field - a field whose type is string
    
    mapping - a truthvalue mapping between boolean values and strings
    
    Returns:
    
    the function that provides the conversion
  - toBoolean
```
public static ScalarValuedFunction toBoolean(ScalarValuedFunction expr,
                                             TruthValues mapping)
```
    Convert a string typed expression into a boolean type.
    
    Parameters:
    
    expr - a function expression whose return type is string
    
    mapping - a truthvalue mapping between boolean values and strings
    
    Returns:
    
    the function that provides the conversion
  - toDate
```
public static ScalarValuedFunction toDate(String field)
```
    Convert a string typed field into a date type.
    
    Parameters:
    
    field - a field whose type is string
    
    Returns:
    
    the function that provides the conversion
  - toDate
```
public static ScalarValuedFunction toDate(ScalarValuedFunction expr)
```
    Convert a string typed expression into a date type.
    
    Parameters:
    
    expr - a function expression whose return type is string
    
    Returns:
    
    the function that provides the conversion
  - toDate
```
public static ScalarValuedFunction toDate(String field,
                                          String format)
```
    Convert a string typed field into a date type using the given format.
    
    Parameters:
    
    field - a field whose type is string
    
    format - format specification to use to convert string to date
    
    Returns:
    
    the function that provides the conversion
  - toDate
```
public static ScalarValuedFunction toDate(String field,
                                          DateTimeFormatting format)
```
    Convert a string typed field into a date type using the given format.
    
    Parameters:
    
    field - a field whose type is string
    
    format - format instance to use to convert string to date
    
    Returns:
    
    the function that provides the conversion
  - toDate
```
public static ScalarValuedFunction toDate(ScalarValuedFunction expr,
                                          DateTimeFormatting format)
```
    Convert a string typed expression into a date type using the given format.
    
    Parameters:
    
    expr - a function expression whose return type is string
    
    format - format instance to use to convert string to date
    
    Returns:
    
    the function that provides the conversion
  - toTime
```
public static ScalarValuedFunction toTime(String field)
```
    Convert a string typed field into a time type.
    
    Parameters:
    
    field - a field whose type is string
    
    Returns:
    
    the function that provides the conversion
  - toTime
```
public static ScalarValuedFunction toTime(ScalarValuedFunction expr)
```
    Convert a string typed expression into a time type.
    
    Parameters:
    
    expr - a function expression whose return type is string
    
    Returns:
    
    the function that provides the conversion
  - toTime
```
public static ScalarValuedFunction toTime(String field,
                                          String format)
```
    Convert a string typed field into a time type using the given format.
    
    Parameters:
    
    field - a field whose type is string
    
    format - format specification to use to convert string to time
    
    Returns:
    
    the function that provides the conversion
  - toTime
```
public static ScalarValuedFunction toTime(String field,
                                          DateTimeFormatting format)
```
    Convert a string typed field into a time type using the given format.
    
    Parameters:
    
    field - a field whose type is string
    
    format - format instance to use to convert string to time
    
    Returns:
    
    the function that provides the conversion
  - toTime
```
public static ScalarValuedFunction toTime(ScalarValuedFunction expr,
                                          DateTimeFormatting format)
```
    Convert a string typed expression into a time type using the given format.
    
    Parameters:
    
    expr - a function expression whose return type is string
    
    format - format instance to use to convert string to time
    
    Returns:
    
    the function that provides the conversion
  - toTimestamp
```
public static ScalarValuedFunction toTimestamp(String field)
```
    Convert a string typed field into a timestamp type.
    
    Parameters:
    
    field - a field whose type is string
    
    Returns:
    
    the function that provides the conversion
  - toTimestamp
```
public static ScalarValuedFunction toTimestamp(ScalarValuedFunction expr)
```
    Convert a string typed expression into a timestamp type.
    
    Parameters:
    
    expr - a function expression whose return type is string
    
    Returns:
    
    the function that provides the conversion
  - toTimestamp
```
public static ScalarValuedFunction toTimestamp(String field,
                                               String format)
```
    Convert a string typed field into a timestamp type using the given format.
    
    Parameters:
    
    field - a field whose type is string
    
    format - format specification to use to convert string to timestamp
    
    Returns:
    
    the function that provides the conversion
  - toTimestamp
```
public static ScalarValuedFunction toTimestamp(String field,
                                               DateTimeFormatting format)
```
    Convert a string typed field into a timestamp type using the given format.
    
    Parameters:
    
    field - a field whose type is string
    
    format - format instance to use to convert string to timestamp
    
    Returns:
    
    the function that provides the conversion
  - toTimestamp
```
public static ScalarValuedFunction toTimestamp(ScalarValuedFunction expr,
                                               DateTimeFormatting format)
```
    Convert a string typed expression into a timestamp type using the given format.
    
    Parameters:
    
    expr - a function expression whose return type is string
    
    format - format instance to use to convert string to timestamp
    
    Returns:
    
    the function that provides the conversion
  - toString
```
public static ScalarValuedFunction toString(String field)
```
    Convert a scalar type field into a string value. The default formatting per data type will be used. To specify a format, use toText(String, Format).
    
    Parameters:
    
    field - a field whose type is string
    
    Returns:
    
    the function that provides the conversion
  - toString
```
public static ScalarValuedFunction toString(ScalarValuedFunction expr)
```
    Convert the value of an expression into a string value. The default formatting per data type will be used. To specify a format, use toText(String, Format).
    
    Parameters:
    
    expr - the expression to convert
    
    Returns:
    
    the function that provides the conversion
  - toText
```
public static ScalarValuedFunction toText(String field,
                                          Format formatter)
```
    Convert a scalar type field into text using the given format. The format object instance must be able to format the token type of the field being converted.
    
    Parameters:
    
    field - a field whose type is string
    
    formatter - format instance to use to convert values to strings
    
    Returns:
    
    the function that provides the conversion
  - toText
```
public static ScalarValuedFunction toText(ScalarValuedFunction expr,
                                          Format formatter)
```
    Convert the value of an expression into text using the given format. The format object instance must be able to format the token type of the field being converted.
    
    Parameters:
    
    expr - the expression to convert
    
    formatter - format instance to use to convert values to strings
    
    Returns:
    
    the function that provides the conversion
  - toText
```
public static ScalarValuedFunction toText(String field,
                                          String format)
```
    Convert a scalar type field into text using the given format. The format specification must be acceptable to a formatter for the token type of the field being converted.
    
    Parameters:
    
    field - a field whose type is string
    
    format - format specification to use to convert values to strings
    
    Returns:
    
    the function that provides the conversion
  - toText
```
public static ScalarValuedFunction toText(ScalarValuedFunction expr,
                                          String format)
```
    Convert the value of an expression into text using the given format. The format specification must be acceptable to a formatter for the token type of the field being converted.
    
    Parameters:
    
    expr - the expression to convert
    
    format - format specification to use to convert values to strings
    
    Returns:
    
    the function that provides the conversion

Class Conversions

Method Summary

Methods inherited from class java.lang.Object

Method Detail

asBoolean

asBoolean

asBoolean

asFloat

asFloat

asDouble

asDouble

asInt

asInt

asLong

asLong

asMoney

asMoney

asNumeric

asTime

asTime

asNumeric

asDate

asDate

toBinary

toBinary

toChar

toChar

toDouble

toDouble

toDouble

toDouble

toDouble

toFloat

toFloat

toFloat

toFloat

toFloat

toInt

toInt

toInt

toInt

toInt

toLong

toLong

toLong

toLong

toLong

toMoney

toMoney

toMoney

toMoney

toMoney

toNumeric

toNumeric

toNumeric

toNumeric

toNumeric

toBoolean

toBoolean

toBoolean

toBoolean

toDate

toDate

toDate

toDate

toDate

toTime

toTime

toTime

toTime

toTime

toTimestamp

toTimestamp

toTimestamp

toTimestamp

toTimestamp

toString

toString

toText

toText