java sql date time

by

java.sql.Date represents a date, not a date and time. From the docs:

To conform with the definition of SQL DATE, the millisecond values wrapped by a java.sql.Date instance must be ‘normalized’ by setting the hours, minutes, seconds, and milliseconds to zero in the particular time zone with which the instance is associated.

If you want to store a date and time, you should look for another type – e.g. java.sql.Timestamp. EDIT: That’s not suggesting you use a TIMESTAMP column type – as paulsm4 says in the comments, that’s a different thing. However, as far as I can see, JDBC only supports:

  • Date (no, you want a time too)
  • Time (no, you want a date too)
  • Timestamp (includes a date and time, but you don’t want TIMESTAMP SQL semantics)

I would expect using the Java Timestamp type with a DATETIME column to work, although without the level of precision that Timestamp provides.

EDIT: After a bit more research, it looks like you may want to use the java.sql.Time type, but with special driver parameters – at least if you’re using the Microsoft driver. See these docs on configuring JDBC for more information.

More Related Contents:

  1. Hours and seconds are lost when storing a date in the database [closed]
  2. Insert & fetch java.time.LocalDate objects to/from an SQL database such as H2
  3. Is java.sql.Timestamp timezone specific?
  4. java.util.Date vs java.sql.Date
  5. Handling MySQL datetimes and timestamps in Java
  6. Should I use java.util.Date or switch to java.time.LocalDate
  7. handling DATETIME values 0000-00-00 00:00:00 in JDBC
  8. What is the most recommended way to store time in PostgreSQL using Java?
  9. Timezones in SQL DATE vs java.sql.Date
  10. Date columns in SQL-Server (MSSQL-JDBC 3.0) running under Java 1.7.0 retrieved as 2 days in the past
  11. How to convert TimeStamp to Date in Java?
  12. having an exception when saving oracle type object in some entity
  13. Date format conversion error [duplicate]
  14. How do I get the size of a java.sql.ResultSet?
  15. What is the best approach using JDBC for parameterizing an IN clause? [duplicate]
  16. How to tackle daylight savings using TimeZone in Java
  17. Java: Why is the Date constructor deprecated, and what do I use instead?
  18. Regex date format validation on Java
  19. In Java, how do I get the difference in seconds between 2 dates?
  20. Java: getMinutes and getHours
  21. How to check if a date Object equals yesterday?
  22. How to read all rows from huge table?
  23. com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed [duplicate]
  24. dll missing in JDBC
  25. Java, looping through result set
  26. Getting last day of the month in a given string date
  27. Sum two dates in Java
  28. Time: How to get the next friday?
  29. Getting the Return Value from JDBC MSSQL
  30. Why can’t OffsetDateTime parse ‘2016-08-24T18:38:05.507+0000’ in Java 8

Leave a Comment