MS SQL unix timestamp to mm/dd/yyyy conversion
Posted on 2011-09-20
I have a field in a database that contains unix timestamps. I recently discovered that it would be handy to have actual dates in the database for troubleshooting purposes. I only need mm/dd/yyyy, nothing more detailed. I added a column for the date and have been running a clumsy lookup/update query using php. I'm having php do the conversion from unix to actual date. Unfortunately, it's taking forever.
Is there some way within the contructs of SQL to read the unix timestamp from a column and write the corresponding mm/dd/yyyy date format to another column?