• Post Reply Bookmark Topic Watch Topic
  • New Topic

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
Marshal
Posts: 38386
645
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
Marshal
Posts: 38386
645
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:

 
I'm gonna teach you a lesson! Start by looking at this tiny ad:
Why should you try IntelliJ IDEA ?
https://coderanch.com/wiki/696337/IntelliJ-IDEA
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!