What is the best data type to accurately store dates and times for a schedule in Spring Boot

I am creating an application that allows for people to schedule an appointment for a doctor using spring boot. Part of the application contains a table to store the available times and dates for a particular doctor.

The attributes for the table are:

• Id
• Doctor Id
• Time
• Date
• Type
• Comment

My question is what data types would be best to use for the "time" and "date" attribute in Spring Boot that would best allow me to accurately represent and store this data?

I was think a form of list, but I don't know how if it would be the best option.

If you want to store Date and time in separate fields than use LocalDate and LocalTime classes. If you want to keep them in one field you can use LocalDateTime or if you want to have a reference to exact moment you will have to have offset reference, and than you will need to use OffsetDateTime or ZonedDateTime. In general, read up on package java.time.

The answer that Michael gave tells you what data type should you use in your Spring app and you can either create a list of LocalDateTime values to store all the available times or you can implement that rather in your front-end because it would be a lot easier to have an array of hours from your open time until your closing time and retrieving the existing appointments only showing the hours that the doctor is available. After all the implementation would be a lot easier in the front-end assuming you implement one.