Data Type

Read(12814) 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 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 specified data is date or datetime type

Ø  ifnumber()

Find whether the specified data is numeric type

Ø  ifstring()

Find whether the specified data is string type

Ø  iftime()

Find whether the specified data is time 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