datetime

2019独角兽企业重金招聘Python工程师标准>>>

datetime:格式'yyyy-mm-dd hh:MM:ss'
时间范围'1000-01-01 00:00:00' 到  '9999-12-31 23:59:59'

 

mysql> create TABLE USER(
    ->  name VARCHAR(20),
    ->  regtime datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
    -> );
Query OK, 0 rows affected (0.08 sec)

转载于:https://my.oschina.net/u/2253438/blog/678883