How to convert string to mysql date?

R

Roman362016-01-26 01:45:26

MySQL

Roman36, 2016-01-26 01:45:26

There is a column with dates written in the form 06/1/2014 how to make a column with dates 2014-06-1 out of this? I'm not at all special in this, I've already broken my whole head. Thanks in advance!

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

P

Peter, 2016-01-26
@Roman36

STR_TO_DATE('1.06.2014','%d.%m.%Y')

Similar questions

E

Eugene2019-12-19 01:12:07

How to initialize an empty variable? 4Reply

W

WordPress WooCommerce2015-08-18 00:53:32

How to make color tint via php? 4Reply

A

Artcifra2017-08-01 15:13:12

How to view Firebase Cloud Messaging statistics by messages? 2Reply

I

Ivan Ivanov2017-08-22 22:41:00

How to create a relationship between tables? 2Reply

A

alexalexov20192020-03-06 13:20:25

When I work for upwork through an agency, will my hours be kept after I leave the agency? 2Reply

Didn't find what you were looking for?

Ask your question