I=E2=80=99ve been asked to post a question here for a friend.
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=E2=80=9D 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
How does one "grab" the existing data and then change it? Can this be done solely in MySQL, or will she have to grab the data and then manipulate it in PHP or something?
Thanks, Marc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Feb 19
Peter Brawley Re: Changing a field's data in every record
Feb 19, 2017; 04:11
Peter Brawley
Re: Changing a field's data in every record
Feb 19
Reindl Harald Re: Changing a field's data in every record
Feb 19, 2017; 11:53
Reindl Harald
Re: Changing a field's data in every record
Feb 19
Brad Barnett Re: Changing a field's data in every record
Feb 19, 2017; 06:50
Brad Barnett
Re: Changing a field's data in every record
Feb 19
debt Re: Changing a field's data in every record
Feb 19, 2017; 09:04
debt
Re: Changing a field's data in every record
Feb 20
Lucio Chiappetti Re: Changing a field's data in every record
Feb 20, 2017; 10:35
Lucio Chiappetti
Re: Changing a field's data in every record
Feb 20
Reindl Harald Re: Changing a field's data in every record
Feb 20, 2017; 11:25
Reindl Harald
Re: Changing a field's data in every record
Mar 02
Hal.sz S.ndor Re: Changing a field's data in every record
Mar 02, 2017; 08:48
Hal.sz S.ndor
Re: Changing a field's data in every record
Jul 28
Surabhi Bhat MySQL Connector/NET 8.0.12 has been released
Jul 28, 2018; 01:20
Surabhi Bhat
MySQL Connector/NET 8.0.12 has been released
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!