millisecond()

Read(2582) 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.

Parameter:

datetimeExp

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

Return value:

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 function:

year()

month()

day() 

hour()

minute()

second()