Re: Reformatting a DATESTAMP out of a table into a readable display date with SELECT

2001-05-20 Thread Alexander Skwar
So sprach Scot Robnett am Sun, May 20, 2001 at 03:03:55PM -0500: > Anybody out there that can tell me how this is done? Thanks! Yeah, the manual will tell you. In the section 'Date and Time functions', look for 'DATE_FORMAT'. Since you don't know where the manual is, it's online available at ht

Reformatting a DATESTAMP out of a table into a readable display date with SELECT

2001-05-20 Thread Scot Robnett
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 |