How do I initialize a java.sql.Date variable?

Question

I'm trying to initialize a variable called startDate using java.sql.Date.

I've tried...

java.sql.date startDate = "02/04/2015"

But it thinks it's a string.

java.sql.date startDate = 02/04/2015

But it thinks it's an int.

java.sql.date startDate = 02-04-2015

But it displays the error "invalid character constant".

How do I properly initialize this variable?

You create it like you would any other object; but, you will need to parse the String value to a java.util.Date and use this to sees an instance of java.sql.Date — MadProgrammer
– MadProgrammer, Commented Feb 5, 2015 at 2:10

Elliott Frisch · Accepted Answer · 2015-02-05 02:12:11Z

4

One possible approach is to use a SimpleDateFormat and the java.sql.Date(long) constructor like

DateFormat df = new SimpleDateFormat("MM-dd-yyyy");
java.sql.Date sqlDate = new java.sql.Date(df.parse("02-04-2015").getTime());

answered Feb 5, 2015 at 2:12

Elliott Frisch

202k20 gold badges166 silver badges265 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

soMuchToLearnAndShare · Accepted Answer · 2023-05-29 06:08:09Z

0

you could also try

java.sql.Date sqlDate = new java.sql.Date(2020,12,12);

I do not know why this is deprecated, but it is very intuitive for me. basically year, month, day integer.

Update: 10 months ago, my further reading told me never use this old API. See here: https://www.linkedin.com/posts/min-shi-schurr-3859468_how-to-effectively-use-dates-and-timestamps-activity-6873395326397558784-2ehr?utm_source=share&utm_medium=member_ios

edited May 29, 2023 at 6:08

answered Sep 17, 2020 at 17:17

soMuchToLearnAndShare

1,04515 silver badges29 bronze badges

3 Comments

jazz64 Over a year ago

Attention: The deprecated constructor is not working as expected, to set the year to 2020 you have to give 120 (year value minus 1900). Use the date formatter for better readability and support of clean code.

soMuchToLearnAndShare Over a year ago

I have now updated my “answer”

Stephen C Over a year ago

Deleting the Answer would be a better idea (IMO). (What is the point of suggesting an alternative that is deprecated and then giving an incorrect example?)

Collectives™ on Stack Overflow

How do I initialize a java.sql.Date variable?

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related