Mysql time, string, timestamp, cross-turn

Time-to-round string

Select date_format (now (),'%y-%m-%d'); // 2018 - Geneva -  A

Time-to-time stamping

Select Unix_timestamp (now ()); // 1523504912

Time Stamp Turn time

Select From_unixtime (1523504912)//2018-12  One::

Timestamp to String

Select From_unixtime (1523504912,'%y-%d')//2018-   A

String Turn time

Select str_to_date ('2018-04-12','%y-%m-%d'); // 2018 - Geneva -  A

String Turn timestamp

Select Unix_timestamp ('2018-04-12'); // 1523462400

Schedule

The image to the network,%s,%i is not available.

Mysql time, string, timestamp, cross-turn