I have a database that has a MS Access database as an external data source through ODBC from which i am importing data from.
One of the fields is a TimeStamp field which is formatted as the number of seconds since 1970/01/01 00:00:00. So as an example, a record that i imported has a TimeStamp of 1326116674.
I would like to create a second field that calculates the data from the TimeStamp field into a readable format. How would one go about calculating the data from the TimeStamp field into a readable date and time?