Mysql里的日期类型 和JPA里@Temporal

1.date类型

2.time类型

3.datetime类型

1.date

@Temporal(TemporalType.DATE)
private Date birthday;

mysql> desc person;
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| id       | int(11)      | NO   | PRI | NULL    | auto_increment |
| birthday | date         | YES  |     | NULL    |                |
| name     | varchar(255) | YES  |     | NULL    |                |
+----------+--------------+------+-----+---------+----------------+
3 rows in set (0.01 sec)

mysql> select * from person
+----+------------+-------+
| id | birthday   | name  |
+----+------------+-------+
|  1 | 2012-01-03 | tazi2 |
+----+------------+-------+
1 row in set (0.02 sec)

2.

@Temporal(TemporalType.TIME)
private Date birthday;

mysql> desc person;
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| id       | int(11)      | NO   | PRI | NULL    | auto_increment |
| birthday | time         | YES  |     | NULL    |                |
| name     | varchar(255) | YES  |     | NULL    |                |
+----------+--------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

mysql> select * from person;
+----+----------+-------+
| id | birthday | name  |
+----+----------+-------+
|  1 | 16:01:14 | tazi2 |
+----+----------+-------+
1 row in set (0.00 sec)

3.datetime

@Temporal(TemporalType.TIMESTAMP)
private Date birthday;

mysql> desc person;
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| id       | int(11)      | NO   | PRI | NULL    | auto_increment |
| birthday | datetime     | YES  |     | NULL    |                |
| name     | varchar(255) | YES  |     | NULL    |                |
+----------+--------------+------+-----+---------+----------------+
3 rows in set (0.02 sec)

mysql> select * from person;
+----+---------------------+-------+
| id | birthday            | name  |
+----+---------------------+-------+
|  1 | 2012-01-03 16:05:00 | tazi2 |
+----+---------------------+-------+
1 row in set (0.03 sec)

分别表示不同的时间精度

转载于:https://www.cnblogs.com/tazi/archive/2012/01/04/2311584.html