Be able to view timestamps stoed in BIGINT fields as locally formatted dates

[frumbert]

Many of the DB's I work with have dates as unix timestamps stoerd in bigint fields. I have to write queries to format them just to view the table data in anyway that makes sense. If there was a setting for 'intelligently show timestamps as dates' that would be great (i.e. columns of numbers, 10 or so digits long, that start with the first few digits matching the current timestamp). Editing would still just be the raw value.