convert java.sql.Timestamp to java.sql.Date

Question

I have a Timestamp and Date variables and i want to compare it for equality (only date part of course). It was surprise for me that contructor Date(long) saves time part, so this code does not work correct:

date = resultSet.getDate(1);
timestamp = resultSet.getTimestamp(2);    
//...
if (date.equals(new Date (timestamp.getTime())) ...

I solve this with code like:

DateFormat dateFormat = new SimpleDateFormat ("yyyyMMdd");
if (date.equals(dateFormat.parse(dateFormat.format(timestamp)))) ...

Or i can convert timestamp to date in sql query, but i need a timestamp representation too. Is there a better way to cut a time part from Timestamp.

Vitaljok · Accepted Answer · 2016-01-26 14:59:16Z

18

Java 8 approach of conversion:

Date date = Date.valueOf(timestamp.toLocalDateTime().toLocalDate());

And vice versa:

Timestamp timestamp = Timestamp.valueOf(date.toLocalDate().atStartOfDay());

answered Jan 26, 2016 at 14:59

Vitaljok

6333 gold badges7 silver badges13 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 11:44:54Z

3

Using the method from this answer we get:

date = resultSet.getDate(1);
timestamp = resultSet.getTimestamp(2);    
Calendar cal1 = Calendar.getInstance();
Calendar cal2 = Calendar.getInstance();
cal1.setTime(date);
cal2.setTimeInMillis(timestamp.getTime());
boolean sameDay = cal1.get(Calendar.YEAR) == cal2.get(Calendar.YEAR) &&
                  cal1.get(Calendar.DAY_OF_YEAR) == cal2.get(Calendar.DAY_OF_YEAR);

It's worth reading the linked answer as it talks about the shortcomings of this method with respects to timezones and so on (and some of the other answers to that question give alternate approaches which you may prefer).

edited May 23, 2017 at 11:44

CommunityBot

11 silver badge

answered Feb 12, 2013 at 12:16

David Webb

195k57 gold badges319 silver badges302 bronze badges

Comments

Damian Leszczyński - Vash · Accepted Answer · 2013-02-12 12:18:27Z

1

You have three options with this one.

First is to use Yoda time and class DateTimeComparator.getDateOnlyInstance()

Second is to use commons from apache and DateUtils.isSameDay()

Third use the [Calendar] and set the time and compare the year, month and day of year only. As Dave Webb proposed.

answered Feb 12, 2013 at 12:18

Damian Leszczyński - Vash

31k9 gold badges64 silver badges95 bronze badges

Comments

Dave · Accepted Answer · 2016-01-26 15:10:51Z

1

Another approach is to use the "day" part of the epoch value:

Date d = new Date();
Timestamp t = new Timestamp(d.getTime());

long dateEpochDays = d.getTime() % (1000*60*60*24);
long timeStampEpochDays = t.getTime() %(1000*60*60*24);

System.out.println("date: " + dateEpochDays + " timestamp: " + timeStampEpochDays);

answered Jan 26, 2016 at 15:10

Dave

14.3k7 gold badges47 silver badges53 bronze badges

Collectives™ on Stack Overflow

convert java.sql.Timestamp to java.sql.Date

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related