PHP convert query to DATE

Question

I have this code. my problem is the strduedate field is in varchar type. How can I convert that field into datetime so I can perform the greater than query.

scenario.

Given the strduedate in my database is = '01/02/2016'

when I perform the query it says that strduedate is less than current date which is 09/18/2015.

$date_now = new DateTime();

$sql = "UPDATE jrf_tbl SET strifoverdue ='no' WHERE strduedate > '$date_now' ";
$OverDue->updatefields($sql);

STR_TO_DATE(str,format) - STR_TO_DATE(strduedate, '%m/%d/%Y') — Sean
– Sean, Commented Sep 18, 2015 at 3:04

gbe · Accepted Answer · 2015-09-18 03:04:30Z

2

Just use the mysql STR_TO_DATE function like this:

$sql = "UPDATE jrf_tbl SET strifoverdue ='no' WHERE STR_TO_DATE(strduedate, '%m/%d/%Y') > '$date_now' ";
$OverDue->updatefields($sql);

answered Sep 18, 2015 at 3:04

gbe

1,18310 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP convert query to DATE

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related