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 no
Am 20.02.2017 um 10:35 schrieb Lucio Chiappetti:
On Sat, 18 Feb 2017, debt wrote:
How does one "grab" the existing data and then change it? Can this
be done solely in MySQL
I am not sure to understand your question ... you usually manipulate
data inside mysql ... but here it seems t
On Sat, 18 Feb 2017, debt wrote:
How does one "grab" the existing data and then change it? Can this
be done solely in MySQL
I am not sure to understand your question ... you usually manipulate data
inside mysql ... but here it seems to me you are not talking of changing
the d
> On Feb 19, 2017, at 3:50 AM, Brad Barnett wrote:
>
> SUBSTRING_INDEX
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
Erm.
I've seen some weird responses to this. Yes, you can do this.
First -- get the data into a usable format. Then, put it into a usable
format (eg, timestamp for datetime field).
Read up on how mysql interprets date/time data on fields. And, create a
new timestamp or date field.
Then, do
Am 19.02.2017 um 11:11 schrieb Peter Brawley:
On 2/18/2017 15:13, debt wrote:
I’ve 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” in a text
field formatted as 201
On 2/18/2017 15:13, debt wrote:
I’ve 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” in a text field formatted as
2017|02|16|04|58|42 and she wants to conve
I’ve 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” in a text field formatted as
2017|02|16|04|58|42 and she wants to convert it to a more human readable for
