Derives the minutes value from a Datetime value. Minutes are expressed as integers from 0 to 59.

derive type:single value:MINUTE(MyDate)

Output: Generates a column of values that retrieve the two-digit hour values from the MyDate column.

derive type:single value:MINUTE(datetime_col)

ArgumentRequired?Data TypeDescription
datetime_colYdatetimeName of column whose minute values are to be computed

datetime_col

Name of the column whose minute value is to be computed.

Required?Data TypeExample Value
YesDatetimemyDate

Example - Date element functions