How to save DATE at the MySQL column

Question

I am building simple REST with Spring Boot, MySQL, Hibernate. Want to save current date (autogenerated) using Hibernate but everytime i test it in the PostMan i get Null

@Entity
@Table (name="purchase")
public class Purchase {
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
@Column(name = "name")
private String name; 
@Temporal(TemporalType.DATE)
@Column(name="createat")
private Date created;}
CREATE TABLE `purchase`.`purchase` (
`id` INT NOT NULL             AUTO_INCREMENT,
`name` VARCHAR(45) NOT NULL,
`createat` DATE,
PRIMARY KEY (`id`));

I Need to save current date to my createat COLUMN

You can add a default value in Java with private Date created = new Date();, I'm not sure this is what you were asking for. — vicpermir
– vicpermir, Commented May 29, 2019 at 7:31
Possible duplicate of How can I use DB side default value while use Hibernate save? — Joakim Danielson
– Joakim Danielson, Commented May 29, 2019 at 8:13

Vikas Suryawanshi · Accepted Answer · 2019-05-29 08:30:39Z

2

Using Hibernate you can just use @CreationTimestamp to insert default date.

@CreationTimestamp
@Temporal(TemporalType.TIMESTAMP)
@Column(name = "create_date")
private Date createDate;

and @UpdateTimestamp to update the value if necessary

@UpdateTimestamp
@Temporal(TemporalType.TIMESTAMP)
@Column(name = "modify_date")
private Date modifyDate;

answered May 29, 2019 at 8:30

Vikas Suryawanshi

5221 gold badge5 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Yuriy Shkinder Over a year ago

Thank you very much, that @CreationTimestamp was exactly what I needed

Collectives™ on Stack Overflow

How to save DATE at the MySQL column

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related