Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • 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:
  • Campbell Ritchie
  • Liutauras Vilda
  • Bear Bibeault
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Paul Clapham
  • Devaka Cooray
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Frits Walraven
Bartenders:
  • Carey Brown
  • salvin francis
  • Claude Moore

Add string thar represents offset time to a Timestamp  RSS feed

 
Ranch Hand
Posts: 30
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
Posts: 39234
727
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
Ranch Hand
Posts: 30
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
Posts: 39234
727
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
Ranch Hand
Posts: 30
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
Ranch Hand
Posts: 30
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:

 
He repaced his skull with glass. So you can see his brain. Kinda like this tiny ad:
Create Edit Print & Convert PDF Using Free API with Java
https://coderanch.com/wiki/703735/Create-Convert-PDF-Free-Spire
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!