View Source

Derives the seconds value from a Datetime value. Source value can be a a reference to a column containing Datetime values or a literal.

If the source Datetime value does not include a valid input for this function, a missing value is returned.
If the input values do not contain milliseconds, the generated output is expressed as integers from 0 to 59.
If the input values contain milliseconds, the generated output is a floating point value.

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.

Missing values for this function in the source data result in missing values in the output.
Invalid or out-of-range source values generate missing values in the output.
Multiple columns and wildcards are not supported.

Required?	Data Type	Example Value
Yes	Datetime	`myDate`