MICROSECSTODAYS

MICROSECSTODAYS returns a FIXED BINARY(31) value that represents the number of microseconds x converted to days, ignoring incomplete days.

Read syntax diagramSkip visual syntax diagramMICROSECSTODAYS( x)
x
An expression that specifies the number of microseconds. The value for x must have computational type and will be converted to FIXED BINARY(63) if necessary.

MICROSECSTODAYS(x) is the same as x/(24*60*60*1_000_000).

For an example, see SECS.