For java.sql.Date AND java.sql.timestamp, can both be converted to datetime in sql server?

Question

I have java.sql.Date and java.sql.timestamp objects in my Java code. I would like to insert them into a SQL Server column. Can this column's datatype be datetime?

From this https://learn.microsoft.com/en-us/sql/language-extensions/how-to/java-to-sql-data-types?view=sql-server-ver15 there are difference between java.sql.Date and timestamp, but I believe both would convert to datetime. Please correct me if I am wrong.

Why don't you just try it?

Simon Martinelli
– Simon Martinelli

2021-03-19 19:02:15 +00:00
Commented Mar 19, 2021 at 19:02 — Simon Martinelli
– Simon Martinelli, Commented Mar 19, 2021 at 19:02
The documentation would answer this question.

Dale K
– Dale K

2021-03-19 21:05:15 +00:00
Commented Mar 19, 2021 at 21:05 — Dale K
– Dale K, Commented Mar 19, 2021 at 21:05

Arvind Kumar Avinash · Accepted Answer · 2021-03-19 19:08:02Z

1

Use java.sql.Date when you have to deal with only the date part (i.e. year, month and day).
Use java.sql.Timestamp when you have to deal with both, date and time.

answered Mar 19, 2021 at 19:08

Arvind Kumar Avinash

81k10 gold badges98 silver badges144 bronze badges

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

Collectives™ on Stack Overflow

For java.sql.Date AND java.sql.timestamp, can both be converted to datetime in sql server?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related