> 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
