What is the proper Drupal way to deal with timestamp fields?
I wanted to create two timestamp fields in a MySQL table, but ran into some problems that I can't solve (see this question). So now I want to try it with the INT fields and Unix timestamps that Drupal uses.
The two columns in question are for "created" and "updated" purposes. What is the Drupal way to store a record with the current (UTC) time and how can I retrieve those timestamps in the user's own timezone? My server is on UTC time and I'm using Drupal 7.