aspose file tools*
The moose likes Java in General and the fly likes sql date and time - how I construct one date out of them? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "sql date and time - how I construct one date out of them?" Watch "sql date and time - how I construct one date out of them?" New topic
Author

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

John Landon
Ranch Hand

Joined: Sep 25, 2008
Posts: 227
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
Sheriff

Joined: Oct 01, 2001
Posts: 2853
    
  11

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:



I'll leave it to you to verify that works.
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19718
    
  20

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


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
Greg Charles
Sheriff

Joined: Oct 01, 2001
Posts: 2853
    
  11

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: sql date and time - how I construct one date out of them?