SQL Query that changes Epoch to Date
"Steve Bluck" <[email protected]> Fri, 24 Nov 2006 15:59:01 +1300
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
Hi All, I've been volunteered to look after a MySQL 4.0.23 database (I know it's old, but I thought I'd learn what I was doing before updating) which records dial-up radius users log details and all dates etc fileds in the tables are in Epoch format. I'm relatively comfortable using SQL queries to retrieve data but need to convert Epoch seconds to a 'me' friendly format to add meaning when debugging. Any help would be appreciated. Cheers Steve -- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/[email protected]