4 messages in com.mysql.lists.win32RE: SQL Query that changes Epoch to Date| From | Sent On | Attachments |
|---|---|---|
| Steve Bluck | 23 Nov 2006 18:58 | |
| Bonnett, John | 23 Nov 2006 20:52 | |
| Randy Clamons | 24 Nov 2006 12:49 | |
| Steve Bluck | 25 Nov 2006 15:10 |
| Subject: | RE: SQL Query that changes Epoch to Date |
|---|---|
| From: | Bonnett, John (John...@vision.zeiss.com) |
| Date: | 11/23/2006 08:52:51 PM |
| List: | com.mysql.lists.win32 |
This might help http://www.rebol.net/cookbook/recipes/0051.html
______________
Carl Zeiss Vision Computer Scientist Asia Pacific
John Bonnett
19 Cooroora Crescent Lonsdale SA 5160 Australia
Phone: +61 (0) 8 8392 8366 Fax: +61 (0) 8 8392 8400 Email: john...@vision.zeiss.com Web: www.vision.zeiss.com
This email, including any attachments, is intended for the sole use of the intended recipient(s) and may contain information that is confidential, privileged and/or the sender's work. Any review or distribution by any other person is prohibited. If you are not an intended recipient, please immediately contact the sender and delete all copies.
-----Original Message----- From: Steve Bluck [mailto:ste...@staff.inhb.co.nz] Sent: Friday, 24 November 2006 1:29 PM To: win...@lists.mysql.com Subject: SQL Query that changes Epoch to Date
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