Data Type

Read(2387) Label: function, convert,

  esProc offers the following functions that return data type information.

Ø  “”,$[]

String

Ø  ‘’

Variable name

Ø  0x12

Hexadecimal long integer

Ø  1L

Long integer

Ø  \s

A character that invokes an alternative interpretation on special characters in a string

Ø  bool()

Convert to a boolean value

Ø  date()

Convert a string or an integer to a date

Ø  datetime()

Convert a string or a long integer to a datetime

Ø  decimal()

Convert to big decimal number

Ø  float()

Convert to double-precision floating-point number

Ø  false

False value

Ø  ifdate()

Find whether the type of parameter is date or datetime

Ø  ifnumber()

Find whether the parameter is of numeric data type

Ø  ifstring()

Find whether the type of parameter is string

Ø  iftime()

Find whether the parameter is of time data type

Ø  int()

Convert to integer

Ø  k()

Generate a serial byte with a specified number of bytes

Ø  k{}

Get certain bytes from a serial byte to form a new serial byte

Ø  long()

Convert to long integer

Ø  k.len()

Get the length of a serial byte

Ø  number()

Convert to number

Ø  null

Null value

Ø  string()

Convert to string

Ø  time()

Convert a string or an integer to a time

Ø  true

True value