FROM_UNIXTIME() Jeff
-----Original Message----- From: Brei, Matt [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 1:42 PM To: [EMAIL PROTECTED] Subject: Epoch time to MM-DD-YYYY I have a small database for logging support tickets for the IS department that logs all timestamps in UNIX epoch time. I'm trying to use Crystal Reports for various reporting and I'm having a problem with timestamps. Is there a MySQL function that will convert epoch to a human readable format? Thanks Matt Brei -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]