Difference Betwixt Java.Util.Date As Well As Java.Sql.Date Inwards Coffee - Jdbc Interview Question

Difference betwixt java.util.Date together with java.sql.Date inwards Java or why does Java has java.sql.Date if in that place is already a Date shape inwards coffee util parcel is a common coffee interview question. There is ever confusion amid many Java developer familiar alongside both java.util.Date together with java.sql.Date. Though many of them already using java.sql.Date to interface alongside DATE type of whatsoever relational database similar mysql, oracle or whatsoever other database. In this Java tutorial nosotros volition run into some differences betwixt java.sql.Date together with java.util.Date which volition aid to empathise both of them better.

This Java tutorial is inwards continuation of our before post service on java.util.Date similar How to convert String to Date inwards Java together with how to larn electrical flow Date together with Time value inwards GMT timezone.  if yous haven't read them already yous may uncovering them interesting together with useful. If yous similar JDBC articles together with thus checkout some JDBC Performance tips and  Benefits of PreparedStatement inwards Java.

Difference betwixt java.util.Date together with java.sql.Date inwards Java

Here are few differences on java.sql.Date together with java.util.Date inwards Java inwards betoken format, if yous whatsoever other departure betwixt them which is worth noting together with thus delight post service inwards comments :

1. As per Javadoc java.sql.Date is a sparse wrapper approximately millisecond value which is used past times JDBC to position an SQL DATE type.

2. java.sql.Date merely represent DATE without fourth dimension information spell java.util.Date stand upwards for both Date together with Time information. This is the major differences why java.util.Date tin ship away non straight map to java.sql.Date.

3. In company to suppress fourth dimension information together with to confirm alongside Definition of ANSI SQL DATE type, the millisecond values used inwards java.sql.Date event must live on "normalized past times setting the hours, minutes, seconds together with milliseconds to nil inwards the timezone alongside with DATE event is associated. In other words all fourth dimension related information is removed from java.sql.Date class.

>

Why produce yous require java.sql.Date if in that place is already java.util.Date exits ?

database is to a greater extent than unopen to java.util.Date, It extends java.util.DATE together with if yous are using java.util.DATE inwards your Class to stand upwards for DATE value its improve to role TIMESTAMP type inwards Database together with java.sql.Time inwards JDBC or DAO code.

By the means if yous larn this JDBC interview enquiry correct in that place are to a greater extent than interesting questions to comes every bit follow-up similar :

What is departure betwixt java.sql.Date, java.sql.Time together with java.sql.Timestamp ?

How to convert java.sql.Date into java.util.Date together with vice versa ?

Better to gear upwards for these questions likewise , I volition  try to post service answers of these JDBC questions inwards another post.

That's all on difference betwixt java.sql.Date together with java.util.Date. In summary sql engagement stand upwards for alone Date information (e.g. year, month, day) spell util Date stand upwards for both engagement together with fourth dimension information. Other Java questions yous may like

Further Learning
JSP, Servlets together with JDBC for Beginners: Build a Database App
Complete JDBC Programming Part 1 together with 2
Why Java doesn’t back upwards multiple inheritance

Why Operator overloading is non supported inwards Java

Difference betwixt overloading together with overriding inwards Java

Difference betwixt Runnable together with Thread inwards Java

Why char array is improve than String for storing password

Difference betwixt throw together with throws inwards Java

Sumber https://javarevisited.blogspot.com/