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?

Angular 9 Tutorial: Learn to Build a CRUD Angular App Quickly

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

Brave, Chrome, Firefox, Opera or Edge: Which is Better and Faster?

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

What is new features in Javascript ES2020 ECMAScript 2020

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.

The Complete PHP MySQL Professional Course with 5 Projects

The Complete PHP MySQL Professional Course with 5 Projects

PHP Interview Questions with Solutions: Prepare for PHP Interview

Prepare for PHP Interviews. Set Variable With php.ini File. Logic & Output Behind PHP Code Segment. Class Concept, Error & Functions in PHP. Start PHP Now!