Databases
StackOverflow2013
Postsdbo
POConvert java.sql.Timestamp to java.sql.Timestamp in another timezone
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POConvert java.sql.Timestamp to java.sql.Timestamp in another timezone
    primarykey
    data
    text
    <p>I am in need to manipulate on java.sql.Timestamp. </p> <p>Input to the function is: Formatted DateTime in java.sql.Timestamp [Possible date formats are: MM/dd/yyyy hh:mm:ss aa, MM/dd/yyyy hh:mm:ss, MM/dd/yyyy hh:mm aa, MM/dd/yyyy HH:mm, MM/dd/yy hh:mm aa, MM/dd/yy HH:mm, MM/dd/yyyy, and some others]</p> <p>Required Output: java.sql.Timestamp in another Timezone the same formatted DateTime as input</p> <p>So basically I need to change timezone of the DateTime in java.sql.Timestamp </p> <p>I have seen other posts, which mention to use JODA, but I can't use it due to some restrictions. </p> <p>I have tried - to convert java.sql.Timestamp to java.date.Calendar, - then change the timezone, - then convert to it to date - format date to the same formatted datetime </p> <p>See the code below:</p> <pre><code>Timestamp ts = "2012-06-20 18:22:42.0"; // I get this type of value from another function Calendar cal = Calendar.getInstance(); cal.setTime(ts); cal.add(Calendar.HOUR, -8); String string = cal.getTime().toString(); // return value is in " DAY MMM dd hh:mm:ss PDT yyyy " format i.e. Wed Jun 20 10:22:42 PDT 2012 SimpleDateFormat formatter = new SimpleDateFormat("MM/dd/yyyy hh:mm:ss"); // This could be any format required Date date; try { date = formatter.parse(string); // I am getting exception here on parsing } catch (ParseException e1) { e1.printStackTrace(); } </code></pre> <p>Can anyone tell me what is wrong here, or is there any other way to manipulate on Timezone for java.sql.Timestamp ? </p> <p>Thanks. </p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USsankethm7
    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
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POConvert java.sql.Timestamp to java.sql.Timestamp in another timezone
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhat is the exception?
      singulars
      1. POConvert java.sql.Timestamp to java.sql.Timestamp in another timezone
      1. USTiago
    2. COI am getting java.text.ParseException: Unparseable date: "Wed Jun 20 10:22:42 PDT 2012"
      singulars
      1. POConvert java.sql.Timestamp to java.sql.Timestamp in another timezone
      1. USsankethm7
    3. COSo there you have it, format is completely wrong no?
      singulars
      1. POConvert java.sql.Timestamp to java.sql.Timestamp in another timezone
      1. USTiago
 

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