Shulou(Shulou.com)06/01 Report--

1. Use: DATE_FORMAT to convert dates into strings, or strings to convert dates

(1) convert time to string

Convert the system time to a string

Mysql > select date_format (now (),'% y%m%d% HRV% iRO% s')

+-+

| | date_format (now (),'% y%m%d% HRV% iRV% s') |

+-+

| | 160510 06:10:30 |

+-+

Extension:% Y: year% c: month% d: day% H: hour% I: minute% s: second (2) convert string to date

Partition_key field information is: 160101

Mysql > select date_format (partition_key,'%y-%m-%d') from t_order

+-+

| | date_format (partition_key,'%y-%m-%d') |

+-+

| | 16-01-01 | |

| | 16-01-01 | |

| | 16-01-01 | |

| | 16-01-01 | |

| | 16-01-01 | |

| | 16-01-01 | |

| | 16-01-01 | |

| | 16-01-01 | |

| | 16-01-01 | |

| | 16-01-01 | |

| | 16-01-01 | |

| | 16-01-01 | |

| | 16-01-01 | |

| | 16-01-01 | |

+-+

14 rows in set (1.67 sec)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.