ETL: GetMilliSecond

Extract the millisecond component from a datetime expression. Use GETMILLISECOND for sub-second precision timing in Integrate.io ETL pipelines.

Description

Returns the millisecond from a datetime expression.

Syntax

GetMilliSecond(datetime_expression)

Examples

GetMilliSecond(ToDate('2013-09-10T08:02:31.667Z')) returns 667

Return value datatype

Integer

Impact of null value

If input is null, returns null.