What Is Divergence Betwixt Java.Sql.Time, Java.Sql.Timestamp In Addition To Java.Sql.Date - Jdbc Interview Question
Monday, July 9, 2018
Add Comment
Difference betwixt java.sql.Time, java.sql.Timestamp too java.sql.Date is most mutual JDBC enquiry appearing on many core Java interviews. As JDBC provides 3 classes java.sql.Date, java.sql.Time too java.sql.Timestamp to correspond appointment too fourth dimension too y'all already convey java.util.Date which tin correspond both appointment too time, this enquiry poses lot of confusion amid Java programmer too that’s why this is i of those tricky Java questions which is tough to answer. It becomes actually tough if differences betwixt them is non understood correctly. We convey already seen roughly oft asked or mutual JDBC questions similar why JDBC has java.sql.Date despite java.util.Date too Why purpose PreparedStatement inward Java in our final tutorials too nosotros volition encounter departure betwixt java.sql.Date, java.sql.Time too java.sql.Timestamp inward this article. By the agency apart from these JDBC interview questions, if y'all are looking to teach most from JDBC y'all tin also encounter 4 JDBC functioning tips too 10 JDBC best practices to follow. Those article non exclusively attention y'all to sympathise too purpose JDBC amend only also attention on interviews. Let’s come upward dorsum to departure sql time, timestamp too sql date.
Difference betwixt java.sql.Time, java.sql.Timestamp too java.sql.Date:
JDBC inward Java has 3 date/time types corresponding to DATE, TIME too TIMESTAMP type of ANSI SQL. These types are used to convert SQL types into Java types. 1) First departure on java.sql.Time vs java.sql.Timestamp vs java.sql.Date is almost information they correspond :
JDBC TIME or java.sql.Time correspond exclusively fourth dimension information e.g. hours, minutes too seconds without whatever appointment information.
JDBC DATE or java.sql.Date correspond exclusively appointment information e.g. year, month too day without whatever fourth dimension information.
JDBC TIMESTAMP or java.sql.Timestamp represent both appointment too fourth dimension information including nanosecond details.
2) java.sql.Time too java.sql.Timestamp extends java.util.Date course of report only java.sql.Date is independent.
3) Time information from java.sql.Date too Date information from java.sql.Time is normalized too may laid to nada inward social club to confirm ANSI SQL DATE too TIME types.
So departure betwixt Time, Timestamp too Date of SQL bundle is clear inward price of what they represent. On opposite java.util.Date also correspond Date too fourth dimension information only without nanosecond details too that's why many people prefer to shop appointment equally long value (millisecond passed from epoch Jan 1, 1970 00:00:00.000 GMT). If y'all compare to java.sql.Timestamp alongside equals() method it volition render false equally value of nanosecond is unknown.
That's all on departure betwixt java.sql.Date, java.sql.Time too java.sql.Timestamp. All differences lies on what just the represent. This kinds of questions are worth looking earlier going to whatever JDBC interview equally fourth dimension too appointment are integral business office of whatever JDBC interview.
Further Learning
JSP, Servlets too JDBC for Beginners: Build a Database App
Complete JDBC Programming Part 1 too 2
How to connect Oracle database from Java program
0 Response to "What Is Divergence Betwixt Java.Sql.Time, Java.Sql.Timestamp In Addition To Java.Sql.Date - Jdbc Interview Question"
Post a Comment