Hello Andy, Tuesday, December 04, 2001, 10:42:39 PM, you wrote:
AA> I have vpopmail 5.0 running with logging to MySQL. However the AA> Timestamp field contains numbers like 1007484409. Is there a way to AA> decipher that to an actual time and date? Time since 'epoch' In mysql i can convert it in human readable format with mysql> select FROM_UNIXTIME(1007484409) as time; +---------------------+ | time | +---------------------+ | 2001-12-04 11:46:49 | +---------------------+ 1 row in set (0.00 sec) mysql> Most of Languages,modules,applications understands this format. AA> Thanks AA> Andy Abshagen AA> System Administrator AA> Data-Vision, Inc. AA> www.d-vision.com, [EMAIL PROTECTED] AA> 219-243-2125 x306, 888-925-8625 ------------ With respect, Yuri A. Kabaenkov [EMAIL PROTECTED]
