mysql - time

mysql> select current_timestamp();

+---------------------+

| current_timestamp() |

+---------------------+

| 2016-06-02 14:14:37 |

+---------------------+

1 row in set (0.00 sec)

 

mysql> select unix_timestamp(current_timestamp());

+-------------------------------------+

| unix_timestamp(current_timestamp()) |

+-------------------------------------+

|                          1464848262 |

+-------------------------------------+

 

 

1 row in set (0.00 sec)

 

mysql> select current_time();

+----------------+

| current_time() |

+----------------+

| 14:14:47       |

+----------------+

 

1 row in set (0.00 sec)