[MySQL (MariaDB)] 날짜 시간 조회

날짜 시간 조회 | MySQL (MariaDB)

2011.01.05 10:23:39 | 2011.01.05 10:23:39 | 429 | Aiden

❮ ❯

mysql> select sysdate();
+---------------------+
| sysdate()           |
+---------------------+
| 2011-01-05 10:22:45 | 
+---------------------+
1 row in set (0.00 sec)

mysql> select date_format(sysdate(),'%Y-%m-%d %H:%i:%s');
+--------------------------------------------+
| date_format(sysdate(),'%Y-%m-%d %H:%i:%s') |
+--------------------------------------------+
| 2011-01-05 10:22:58                        | 
+--------------------------------------------+
1 row in set (0.00 sec)

mysql> select unix_timestamp();
+------------------+
| unix_timestamp() |
+------------------+
|       1294190586 | 
+------------------+
1 row in set (0.00 sec)

mysql> select from_unixtime(unix_timestamp());
+---------------------------------+
| from_unixtime(unix_timestamp()) |
+---------------------------------+
| 2011-01-05 10:23:25             | 
+---------------------------------+
1 row in set (0.00 sec)

mysql> select from_unixtime(unix_timestamp(),'%Y-%m-%d %H:%i:%s');
+-----------------------------------------------------+
| from_unixtime(unix_timestamp(),'%Y-%m-%d %H:%i:%s') |
+-----------------------------------------------------+
| 2011-01-05 10:23:38                                 | 
+-----------------------------------------------------+
1 row in set (0.00 sec)