Databases
StackOverflow2013
Postsdbo
PODatabase datetime to java.util.Date conversion with timezone
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODatabase datetime to java.util.Date conversion with timezone
    primarykey
    data
    text
    <p>I have a task of converting, time stored on one of my DB(Sql Server)'s table's column to a specified timezone. The column always contains time in UTC timezone.</p> <p>The problem I am facing is, when hibernate <em>READS</em> the column and sets it to my entity class, it sets the time in the application server's timezone.</p> <p>For Eg: if DB has value - 07 Jul 2012 10:30 (which is actually UTC), the hibernate sets the mapped date field as 07 Jul 2012 10:30 PST (assuming the JVM is running at PST).</p> <p>Now if this date gets converted to any other timezone.. say GMT+5:30, i get unexpected result</p> <p>To fix the above issue... i wrote the following code</p> <pre><code> //Reading the DB time (which does not have timezone info) Date dbDate = entityObj.getDBUtcDate(); //Setting GMT timezone to the date, without modifying the date Calendar c = Calendar.getInstance(TimeZone.getTimeZone("GMT")); c.set(dbDate.getYear(), dbDate.getMonth(), dbDate.getDate()..., dbDate.getMinutes()); Date utcDate = c.getTime(); </code></pre> <p>Using above code.. I could get the DB stored <strong>date</strong> back in <em>UTC</em> timezone, but when I did conversion to some other timezone(say GMT+5:30) using below logic</p> <pre><code>Calendar outCal = Calendar.getInstance(TimeZone.getTimeZone("GMT+5:30")); outCal.setTimeInMillis(utcDate.getTime()); Calendar cal = Calendar.getInstance(); cal.set(Calendar.YEAR, outCal.get(Calendar.YEAR)); cal.set(Calendar.MONTH, outCal.get(Calendar.MONTH)); cal.set(Calendar.DAY_OF_MONTH, outCal.get(Calendar.DAY_OF_MONTH)); cal.set(Calendar.HOUR_OF_DAY, outCal.get(Calendar.HOUR_OF_DAY)); cal.set(Calendar.MINUTE, outCal.get(Calendar.MINUTE)); cal.set(Calendar.SECOND, outCal.get(Calendar.SECOND)); cal.set(Calendar.MILLISECOND, outCal.get(Calendar.MILLISECOND)); //Converted date Date pstTime = cal.getTime(); //Converted time mill seconds long timeMilSec = pstTime.getTime(); </code></pre> <p>The time millisecond of the converted date started coming as negative (-54672...), which seems to be representing an invalid time.</p> <p>My question here is How can i restore the timezone information from DB (without having to have any extra column in DB to specifically store timezone information)?</p> <p>OR</p> <p>How can i convert a DB time into a time having a specified timezone(UTC)?</p> <p><em>PS: I expect the output in the form of java.util.Date/ Calendar because i need to do one more conversion on this date</em></p> <p>Please help me resolving this issue </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USsanbhat
    1. USsanbhat
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload