mysql日期int类型jpa_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)

分别表示不同的时间精度