I have a column "LastUpdated" in a table which uses TIMESTAMP to record the date and time of entries. The format of the column is: mysql> select LastUpdated from DriveLeadTimes; +----------------+ | LastUpdated | +----------------+ | 20010519161625 | +----------------+ 1 row in set (0.04 sec) When I display the result, I would like reformat it so that it reads: 05-19-2001 16:16:25 - OR - May 19, 2001 04:16:25 Anybody out there that can tell me how this is done? Thanks! Scot Robnett [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php