Timestamps with Timezones in Database Tables?

LabKey Support Forum
Timestamps with Timezones in Database Tables? slangley  2012-11-09 13:32
Status: Closed
 
I'll add here the comments of our Andrew Nierman who would also like to weigh in:

That may be true, but I’d say the “best practice” is to store dates in UTC w/ the time zone offset and let the client’s timezone setting translate it for them as needed.
  
Here’s a decent SO “question” on this topic:
http://stackoverflow.com/questions/2532729/daylight-saving-time-and-timezone-best-practices
  
and I’d definitely second the SO recommendation to use JodaTime over any of the Java Library time/date libraries.