On 20-May-01 Scot Robnett wrote: > 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: <random snips> > When I display the result, I would like reformat it so that it reads: > > > May 19, 2001 04:16:25 > > Anybody out there that can tell me how this is done? Thanks! > Yes. date_format(LastUpdated,'%b %d, %Y %T') > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. --------------------------------------------------------------------- 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