I am inserting dates like 2016-03-01T00:00:00, which is in the varchar format. I want to convert into as mysql date and add between condition to get records. I am using STR_TO_DATE function, but I am getting as NULL value.
Abhi_6 0 Newbie Poster
rproffitt 2,701 https://5calls.org Moderator
This reads like a two part question. The first part looks well done as I read priors at https://www.google.com/search?q=Mysql+change+varchar+into+date
The second part is not clear. You should expand what your specifications are.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.