millisecond()

Read(222) Label: datetime value, millisecond,

Description:

Get the millisecond from a specified datetime value.

Syntax:

millisecond(datetimeExp)

Note:

The function gets the millisecond from the datetime value datetimeExp.

Parameters:

datetimeExp

An expression whose result is a date or a datetime value of standard format

Return value:

An integer

Example:

millisecond(datetime("1980-02-27 12:00:02:123 ","yyyy-MM-dd HH:mm:ss:SSS"))

123

millisecond(now())

Milliseconds of the current time

Related functions:

year()

month()

day() 

hour()

minute()

second()