title: how to convert given offset time(in seconds) to Format like +hh:mm in java?
body: <p>i want to give support of timezone..for that am storing the value of date in the database with the UTC Time and then i am converting the time depends on the user local time zone..for that am using this line in my database query </p>
  
  <p><code>CONVERT_TZ(modifiedtime,'+00:00','+05:30')</code> this will give me local time zone for the Indian Standard time...but my question is i have only offset in econds and ther id for the particular user..</p>
  
  <p>so is ther anyway that i can convert offset to format like <code>+05:30 or say +04.00 ,+04.30..</code>
  can anyone give me proper solution that if i can convert this offset which is given in seconds to format like <code>+hh:mm</code> so i can directly give it to query...</p>
  
  <p>Am using liferay 6.1 portal in that i have created My custom portlet..so i need to make it this code in java language...so please can any one guide me?</p>