At 13:49 04/12/2001 -0600, you wrote: >On Tue, 2001-12-04 at 13:42, Andy Abshagen wrote: > > I have vpopmail 5.0 running with logging to MySQL. However the > > Timestamp field contains numbers like 1007484409. Is there a way to > > decipher that to an actual time and date? > >That's unix time returned by the time(NULL) call. Any utility >that understands unix time should be able to convert it to >human readable format. > >ken Jones
MySQL has a built-in function to do this too - FROM_UNIXTIME() see http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Date_and_time_functions Howie -- Howard Jones, [EMAIL PROTECTED] "I see stupid people. They're everywhere. http://wotsit.thingy.com/haj/ They walk around like everyone else. http://www.lesser-evil.com/ They don't even know they're stupid."
