> On Feb 19, 2017, at 3:50 AM, Brad Barnett <li...@l8r.net> wrote:

        Thanks a million, Brad!  That works perfectly.  SUBSTRING_INDEX didn’t 
come up in my searches so this is the first I’ve heard of it.

        Also, as you could see, it wasn’t a true timestamp.  It is only used 
for viewing, not for searching or sorting, so a text field worked perfectly 
fine for that purpose.  However, after reading everyone’s replies, I convinced 
her to change that field to DATETIME and to lose the ‘@‘.  Now they have the 
best of both worlds - more readable data and a true DATETIME field that will be 
more useful should they ever need it to be.

Thanks again,
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql

Reply via email to