MySQL TO_SECONDS()

MySQL 날짜함수, 시간함수

 

TO_SECONDS()

   -

 

TO_SECONDS(expr)

의 형태

 

Given a date or datetime expr, returns the number of seconds since the year 0. If expr is not a valid date or datetime value, returns NULL.

 

mysql> SELECT TO_SECONDS(NOW());
+-------------------+
| TO_SECONDS(NOW()) |
+-------------------+
|       63753308673 |
+-------------------+
1 row in set (0.00 sec)

mysql> SELECT TO_SECONDS(950501);
+--------------------+
| TO_SECONDS(950501) |
+--------------------+
|        62966505600 |
+--------------------+
1 row in set (0.00 sec)

mysql> SELECT TO_SECONDS('2020:04:01 12:34:34');
+-----------------------------------+
| TO_SECONDS('2020:04:01 12:34:34') |
+-----------------------------------+
|                       63752963674 |
+-----------------------------------+
1 row in set (0.00 sec)