MILLISECOND: Obtaining Milliseconds From Time/Timestamp

How to:

The MILLISECOND function returns the number of milliseconds from a time or timestamp value.


Top of page

x
Syntax: How to Obtain the Number of Milliseconds From a Time or Timestamp
MILLISECOND(arg)

where:

arg

Time or timestamp

Is the input value.

This function returns an integer value.



Example: Obtaining the Number of Milliseconds From a Time or Timestamp

MILLISECOND returns the number of milliseconds from a time or timestamp. This example,

MILLISECOND('11:22:33.456')

returns 456.

This example,

MILLISECOND('2001-01-22 10:11:12')

returns 0.


iWay Software