Epoch time to MM-DD-YYYY

2003-07-07 Thread Brei, Matt
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?

RE: Epoch time to MM-DD-YYYY

2003-07-07 Thread Jeff McKeon
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- I have a small database for logging support tickets for the IS department that logs all timestamps in UNIX