Win a copy of Machine Learning Systems: Designs that scale this week in the Scala forum
or Xamarin in Action: Creating native cross-platform mobile apps in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

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

 
Ranch Hand
Posts: 239
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Sheriff
Posts: 3015
12
Firefox Browser IntelliJ IDE Java Mac Ruby
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Sheriff
Posts: 21330
87
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If that doesn't work you can use a couple of Calendar objects:
 
Greg Charles
Sheriff
Posts: 3015
12
Firefox Browser IntelliJ IDE Java Mac Ruby
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Don't mess with me you fool! I'm cooking with gas! Here, read this tiny ad:
Rocket Oven Kickstarter - from the trailboss
https://coderanch.com/t/695773/Rocket-Oven-Kickstarter-trailboss
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!