Win a copy of Hands On Software Engineering with Python this week in the Jython/Python 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:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Bear Bibeault
  • Knute Snortum
  • Liutauras Vilda
Sheriffs:
  • Tim Cooke
  • Devaka Cooray
  • Paul Clapham
Saloon Keepers:
  • Tim Moores
  • Frits Walraven
  • Ron McLeod
  • Ganesh Patekar
  • salvin francis
Bartenders:
  • Tim Holloway
  • Carey Brown
  • Stephan van Hulst

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
Posts: 39054
714
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
Posts: 39054
714
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:

 
He was giving me directions and I was powerless to resist. I cannot resist this tiny ad:
Programmatically Create PDF Using Free Spire.PDF with Java
https://coderanch.com/wiki/703735/Programmatically-Create-PDF-Free-Spire
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!