Data Type

Read(5428) Label: function, convert,

  esProc offers the following functions that return data type information.

Ø  ,$[]

String

Ø 

Variable name

Ø  0x12

Hexadecimal long integer

Ø  1L

Long integer

Ø  \s

Invoke an alternative interpretation on special characters in a string

Ø  bool()

Convert to a boolean value

Ø  date()

Convert a string, an integer or a long 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 key having a specified number of bytes using a (long) integer

Ø  k.sbs()

Get an integer consisting of certain bytes of a serial byte key

Ø  long()

Convert to long integer

Ø  number()

Convert to number

Ø  null

Null value

Ø  string()

Convert to string

Ø  time()

Convert a string or an integer to a time

Ø  true

True value