Converting a varchar datatype to date in php mysql

Converting a varchar datatype to date in php mysql

While defining the database i have a column name called 'date_posted' for which i dont know why i used varchar datatype. I now need to get all the posts which are less than 10 days old .However I now have lots of data so changing the structure might create a problem. Is there any way to convert varchat into data in php code?

While defining the database i have a column name called 'date_posted' for which i dont know why i used varchar datatype. I now need to get all the posts which are less than 10 days old .However I now have lots of data so changing the structure might create a problem. Is there any way to convert varchat into data in php code?

php mysql

What's new in Bootstrap 5 and when Bootstrap 5 release date?

How to Build Progressive Web Apps (PWA) using Angular 9

What is new features in Javascript ES2020 ECMAScript 2020

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Random Password Generator Online

HTML Color Picker online | HEX Color Picker | RGB Color Picker

PhP MySQL Projects

Simpliv LLC, a platform for learning and teaching online courses. We basically focus on online learning which helps to learn business concepts, software technology to develop personal and professional goals through video library by recognized industry experts and trainers.

PHP MySQL Tutorial - User Registration System Using PHP & MySQL

In this PHP MySQL Tutorial, you'll learn how to create a user registration and login system using PHP and a MySQL database.

The Complete PHP MySQL Professional Course with 5 Projects

The Complete PHP MySQL Professional Course with 5 Projects

Hire Dedicated PHP Developer

Looking to hire affordable yet experienced PHP developers? **[Hire Dedicated PHP Developer](https://hourlydeveloper.io/hire-dedicated-php-developer/ "Hire Dedicated PHP Developer")**, who can convert your idea to reality, within the stipulated...

PHP School Management System (PHP Web Application With MySQL Database)

School Management System In PHP (Manage Students, Teachers, Exams and Much More). This Web Application Project is build with PHP and JavaScript programming Language and MySQL Database.