CODEWITHSUNDEEP
phpmysqlsql-server
Himanshu Upadhyay
Himanshu Upadhyay

Reputation: 743

Mysql compare date time

I have varchar field in database and format of that field is like '10 Feb 2016 08:26 PM'.

Now I want to fetch upcoming data, So how can i get that ?

$ctime=strtotime(date("Y-m-d H:i:s"));

if($type=='1'){
    $books = $objData->getAll("select * 
                               from bookings 
                               where custID='".$custID."' 
                                 and fromTime>'".$ctime."'");
}

But I am not getting correct result, please help.

Upvotes: 1

Views: 104

Answers (1)

Alexey Chuhrov
Alexey Chuhrov

Reputation: 1787

First of all, as mentioned in comments you should use proper types for dates. To answer your question, it is still possible to achieve, using STR_TO_DATE mysql function.

$objData->getAll("select * from bookings where custID=".$custID."'
AND unix_timestamp(STR_TO_DATE(fromTime, '%d %b %Y %h:%i %p')) > ".time());

Link: Convert VARCHAR timestamp to TIMESTAMP?

Upvotes: 3

Related Questions