How to insert Date and Time from script into PostgreSQL database while using java.time.LocalDateTime

Question

I'm having a problem with inserting Time correctly into the PostgreSQL database. Making web app with SpringBoot, using JPARepository and hibernate. Using this dialect:

spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.PostgreSQL95Dialect

I have a class:

@Entity
public class Class {
//other stuff
@Column(name = "date_and_time")
private LocalDateTime dateAndTime;

I need some test data and when I start my app with this script:

insert into class(date_and_time) values (DATE('2020-06-10 18:43:20');

the result in my database looks like this 2020-06-10 00:00:00

Is there any way I can insert time properly in my database?

Have you tried marking it as @Temporal(TIMESTAMP) ?

Powerlord
– Powerlord

2020-06-19 00:15:49 +00:00
Commented Jun 19, 2020 at 0:15 — Powerlord
– Powerlord, Commented Jun 19, 2020 at 0:15

Felipe Zavan · Accepted Answer · 2020-06-19 00:12:55Z

1

You are casting your datetime to only date when you use the ‘DATE’ function, so you lose the time information. Simply remove the function and it should work.

answered Jun 19, 2020 at 0:12

Felipe Zavan

1,8531 gold badge20 silver badges36 bronze badges

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

1 Comment

PopovicV Over a year ago

Thank you, that solved my problem. I found out just now that ('2020-06-10 18:43:20')::timestamp also gets the job done.

Collectives™ on Stack Overflow

How to insert Date and Time from script into PostgreSQL database while using java.time.LocalDateTime

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related