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: