MILLISECOND: Obtaining Milliseconds From Time/Timestamp

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

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.

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.