Format String to Date MySQL

Question

SCENARIO

I am trying to migrate data and currently my date value is just a string in the format of Jun 28, 2001 aka MMM DD, YYYY format. I need to convert them into a DateTime object such that it will be displayed as 2001-06-28T00:00:00

QUESTION

I have read about STR_TO_DATE function but I am still having trouble understanding it.

Please help, thank you!

ScaisEdge · Accepted Answer · 2019-07-22 16:21:36Z

2

You could try using '%b %d, %Y'

select str_to_date('Jun 28, 2001', '%b %d, %Y' )

and eventually formatting as

 select date_format(str_to_date('Jun 28, 2001', '%b %d, %Y' ), '%Y-%m-%dT%T')

answered Jul 22, 2019 at 16:21

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kaushal Gupta · Accepted Answer · 2019-07-22 16:23:09Z

1

Use this line :-

select str_to_date('Jun 28, 2001', '%b %d, %Y' )

And go through this link to understand :-

https://www.w3schools.com/sql/func_mysql_str_to_date.asp

answered Jul 22, 2019 at 16:23

Kaushal Gupta

1668 bronze badges

Collectives™ on Stack Overflow

Format String to Date MySQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related