sql date and time - how I construct one date out of them?

[John Landon]

Hi,
I have sql date and sql time. I want to construct one Date object with the date that I have and time that I have.
How?

Thanks.

[Greg Charles]

Do you mean you have a java.sql.Date and java.sql.Time? If I remember right, they are just java.util.Date subclasses that zero out the time and date parts respectively. I think it should be enough to getTime() from both and combine them with a bitwise and. Like:

java.util.Date combinedDate = new Date(sqlDate.getTime() & sqlTime.getTime());  

I'll leave it to you to verify that works.

[Rob Spoor]

If that doesn't work you can use a couple of Calendar objects:

Calendar calendar = Calendar.getInstance();
calendar.setTime(date);
Calendar calendar2 = Calendar.getInstance();
calendar2.setTime(time);
calendar.set(Calendar.HOUR_OF_DAY, calendar2.get(Calendar.HOUR_OF_DAY));
// likewise for minute, second and millisecond

[Greg Charles]

By bitwise and I of course meant bitwise or. Bitwise and would work too, but only if your time and date is January 1, 1970 at midnight GMT.