Re: Changing a field's data in every record

2017/02/18 ... debt:
> 	Is there a formula to change the format of the data in a single field in every record of a table?  She has a "timestamp†in a text field formatted as 2017|02|16|04|58|42 and she wants to convert it to a more human readable format like  2017-02-16 @ 04:58:42

It now occurs to me, long after a working answer has been found, that 
because MySQL is none too picky about the strings that it turns into 
timestamps, that adding a DATETIME field, TS say, and thus updating is 
enough programming:

UPDATE tbl SET TS=timestampFormatted_CharacterStringfield;

MySQL takes any punctuation for a separator, and cares only about the 
numerals between the separators.

There is also the function STR_TO_DATE which takes a string to convert 
and a format string.

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