[web2py] Dealing with UTC and converting to local time

[TheSweetlink]

I want to insert all posts in UTC and convert to local time with
prettydates.

Either the gluon.tools prettydate() or a JS script I got a hold of
convert the time properly.

How could I insert a record that is UTC timestamped in the db but
converted to local timezone when retrieving and viewing the record?

Thanks in advance.

-David