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