| Parameter | Type |
|---|---|
value | datetime, time, datetimestamp |
Returns: integer
Example
query:
SELECT SECONDS(CAST("2018-01-02T10:41:26" AS DATETIME))
results:
| seconds |
|---|
| 26 |
The date function used to return the seconds value of a date, time, or datetime value.
| Parameter | Type |
|---|---|
value | datetime, time, datetimestamp |
query:
SELECT SECONDS(CAST("2018-01-02T10:41:26" AS DATETIME))
results:
| seconds |
|---|
| 26 |
AT_TIME_ZONE, DATE_ADD, DATE_COMPARE, DATE_DIFF, DATE_FORMAT, DATE_PARSE, DATE_PART, DATE_SUB, DATE_TRUNC, DAY, HOURS, MINUTES, MONTH, NOW, YEAR