MICROSECS returns a FIXED BINARY(63) value that is the number of microseconds corresponding to the date d.
>>-MICROSECS--+--------------------------+--------------------->< '-(-+------------------+-)-' '-d--+-----------+-' '-,p-+----+-' '-,w-'
- d
- Specifies a string expression representing a date. If present, d specifies
the input date as a character string representing the date/time specified
in the pattern p. If d is
omitted, it is assumed to be the value returned by TIMESTAMP().
d must have a computational type and should have character type. If not, it is converted to character.
- p
- Specifies one of the supported date/time patterns. If p is
omitted, it is assumed to be the TIMESTAMP pattern, namely 'YYYY-MM-DD-HH.MI.SS.999999'.
p must have a computational type and should have character type. If not, it is converted to character.
- w
- Specifies an expression (such as 1950) that can be converted to an integer. If negative, it specifies an offset to be subtracted from the value of the year when the code runs. If omitted, w defaults to the value specified in the WINDOW compile-time option.
The allowed patterns are listed in Table 2. For an explanation of Lilian format, see Date/time built-in functions.