How to compare date when its save as data type text in database

  • Home
  • WordPress
  • How to compare date when its save as data type text in database

0 Comments

Last updated on

MySQL offers a “STR_TO_DATE” function to convert a date string to a date

$date = date('d-m-Y');
$wpdb->get_results( "SELECT * FROM db_table WHERE STR_TO_DATE(`date`) > '$date'
 " );

*It is not recommended to insert dates into MySQL as text.

WP Guru

WP Guru

Welcome to wpguru.co! I'm Dilip, the founder and chief WordPress expert at WP Guru. With over 10 years of experience in web development and WordPress, I've dedicated my career to helping individuals and businesses create, optimize, and maintain their WordPress websites. I specialize in custom theme and plugin development, plugin integrations, and performance optimization. I also have expertise in Headless WordPress with NextJS, providing modern and highly responsive web solutions. My mission is to empower you with the tools and knowledge you need to succeed online. Whether you're a blogger, an entrepreneur, or running a large enterprise, I'm here to support you every step of the way. Thanks for stopping by WP Guru. Let's make your WordPress journey exceptional together!

Leave a Comment

More from WordPress