Win a copy of Learning OpenStack Networking: Build a solid foundation in virtual networking technologies for OpenStack-based clouds this week in the Cloud/Virtualization forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Knute Snortum
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Ganesh Patekar
  • Stephan van Hulst
  • Pete Letkeman
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Ron McLeod
  • Vijitha Kumara

Add string thar represents offset time to a Timestamp  RSS feed

 
Greenhorn
Posts: 29
1
Eclipse IDE Java Redhat
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

I am loading from one table a Timestamp value, for example 2016-11-16 06:43:19.  Then from another table I load a String value that represent a utc offset, for example "-05:00".
Once I have those 2 values I need to add or subtract them, for example 2016-11-16 06:43:19 - (-05:00) = 2016-11-16 11:43:19



I have no idea how to add those 2 values, any help will be appreciated.
Thanks,
 
author & internet detective
Sheriff
Posts: 38564
654
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you trying to do this in Java or SQL?
 
Fernando Guerrero
Greenhorn
Posts: 29
1
Eclipse IDE Java Redhat
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying to do this in Java.
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 38564
654
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
And what type of object are you trying to use? The Java 8 LocalDateTime or the earlier TimeStamp/Date family? If the later, the Calendar object does what you are looking for.
 
Fernando Guerrero
Greenhorn
Posts: 29
1
Eclipse IDE Java Redhat
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I could use any kind of object. As long as I can do what I need to do.

 
Fernando Guerrero
Greenhorn
Posts: 29
1
Eclipse IDE Java Redhat
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the tip about use Calendar Object, I was able to solve this problem using using your tip.

This is my solution to the problem:

 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!