RE: SQL Query that changes Epoch to Date

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: [email protected]
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:[email protected]] 
Sent: Friday, 24 November 2006 1:29 PM
To: [email protected]
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



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]