CODEWITHSUNDEEP
mysqldatabase
Smple_V
Smple_V

Reputation: 868

How to convert datetime to simple date in Mysql?

Been trying to convert givenDate -> 2009-06-29 00:00:000 into requiredDate ->20090629

Have tried using Convert function but non of them seems to do the trick as the version of MySql doesn't recognize Date_Format either.

Believe there should be a simple way to convert this, any guidance would be appreciated

Upvotes: 0

Views: 106

Answers (1)

John Watson
John Watson

Reputation: 46

you can try this as convering it into convert (nvarchar,giventime,112)

Upvotes: 3

Related Questions