Derives the seconds value from a Datetime value. Source value can be a a reference to a column containing Datetime values or a literal. |
derive type:single value:SECOND(MyDate) |
Output: Generates a column of values that retrieve the two-digit hour values from the MyDate
column.
derive type:single value:SECOND(datetime_col) |
Argument | Required? | Data Type | Description |
---|---|---|---|
datetime_col | Y | datetime | Name of column whose second values are to be computed |
Name of the column whose seconds value is to be computed.
Required? | Data Type | Example Value |
---|---|---|
Yes | Datetime | myDate |