java date of today

Question

I am trying to generate the date of today. But I always get: "1969-12-31" as the output.

here my code:

java.util.Date d1 = new java.util.Date();

java.sql.Date sqlDate = new java.sql.Date(d1.getDate());

I want to add it in a sql table, what am I doing wrong?

Any suggestions?

Answer 1

d1.getDate() will give an int representing the current date. Eg: 23.

What you need is d1.getTime().

java.sql.Date sqlDate = new java.sql.Date(d1.getTime());

Answer 2

java.sql.Date date = new java.sql.Date(Calendar.getInstance().getTime().getTime());

Answer 3

java.time

In Java 8 and later you should make use of the new java.time framework. These new classes supplant the old classes which have proven so troublesome.

Time Zone

Note that time zone is crucial in determining a date.

ZoneId zoneId = ZoneId.of( "America/Montreal" );
LocalDate localDate = LocalDate.now( ZoneId );
java.sql.Date d = java.sql.Date.valueOf( localDate );

---

About java.time

The java.time framework is built into Java 8 and later. These classes supplant the troublesome old legacy date-time classes such as java.util.Date, Calendar, & SimpleDateFormat.

The Joda-Time project, now in maintenance mode, advises migration to the java.time classes.

To learn more, see the Oracle Tutorial. And search Stack Overflow for many examples and explanations. Specification is JSR 310.

You may exchange java.time objects directly with your database. Use a JDBC driver compliant with JDBC 4.2 or later. No need for strings, no need for java.sql.* classes.

Where to obtain the java.time classes?

• Java SE 8, Java SE 9, Java SE 10, Java SE 11, and later - Part of the standard Java API with a bundled implementation.
  • Java 9 adds some minor features and fixes.
• Java SE 6 and Java SE 7
  • Most of the java.time functionality is back-ported to Java 6 & 7 in ThreeTen-Backport.
• Android
  • Later versions of Android bundle implementations of the java.time classes.
  • For earlier Android (<26), the ThreeTenABP project adapts ThreeTen-Backport (mentioned above). See How to use ThreeTenABP….

The ThreeTen-Extra project extends java.time with additional classes. This project is a proving ground for possible future additions to java.time. You may find some useful classes here such as Interval, YearWeek, YearQuarter, and more.

Answer 4

The getDate() function is deprecated.

Try use this:

java.util.Date d1 = new java.util.Date();

java.sql.Date sqlDate = new java.sql.Date(d1.getTime());

Answer 5

java.util.date.getDate documentation says that method is deprecated and time that it is returning is actually a base epoch time which begins from 1970-01-01.Learn more about it on https://en.wikipedia.org/wiki/Unix_time

In order to get the actual date you need to do the following:

java.sql.Date sqlDate = new java.sql.Date(new java.util.Date().getTime());