title: Want to store utc time in my database, and at the UI level a timezone specific timestamp
body: <p>For event based columns in my database like createdDate I want to store a UTC value.</p>
  
  <p>I am looking for advice if what I am currently doing will solve my problem correctly.</p>
  
  <ol>
  <li>In postgresql, I will use a timestamp without timezone column</li>
  <li><p>In my scala (similiar to java) code, I will generate a timestamp like:</p>
  
  <pre><code>val currentMs: Long = System.currentTimeMillis
  new java.sql.Timestamp(currentMs)
  </code></pre></li>
  <li><p>I will save that value to the database.  All my servers time will be in synch.
  Now at the database level, I am storing a pure UTC value.</p></li>
  <li><p>When I retrieve data from the database, I will use <a href="http://www.joda.org/joda-time/" rel="nofollow">Joda-Time</a> which will take the timestamp value from the database and then convert the value to a particular timezone.</p></li>
  </ol>
  
  <p>Is this the correct way of doing UTC?
  Am I missing something here because this topic is confusing when you google about it :)</p>
  
  <p><strong>Note: This is a brand new project so I can change things around without issue.</strong></p>
  
  <p><b>Update</b></p>
  
  <p>In Step#2, instead of storing the value from a java.sql.Timestamp, what if I just stored the raw currentMs value in a long column.  Then in the UI I would convert the unix time to a particular timezone based on the logged in user.</p>
  
  <p>Is this a suitable?</p>