使用PHP MySql从我的数据库中选择日期而无需秒 [英] Select date from my db without seconds using PHP MySql

问题描述

好吧， 我将日期和分钟和秒保存在数据库中.

Well, I save the date's with minutes and second in my database.

我想检查日期是否来自my db = to date today.

And I want to check if the date from my db = to date today.

我阅读了有关此内容，但我不知道如何在Date_format中使用 也许是因为我的Date是varchar(255)..

I read about this, and I don't know how to use in Date_format Maybe because my Date is varchar(255)..

感谢帮助(:

感谢所有(:

推荐答案

没有答案，我有一个小问题.

Its not answer, I have a small problem..

我尝试过:

$dbdate = "21/08/2015 10:13";

.

   $select_last_vote = mysql_query("SELECT `Date` FROM `Vote` WHERE `IP` = '$ip' AND `VoteID` = '$VoteID' order by `Date` DESC LIMIT 1;");
            $select_last_vote = mysql_fetch_array($select_last_vote);
            $dbdate = $select_last_vote["Date"];
            $takeResult = mysql_query("SELECT DATE_FORMAT(STR_TO_DATE('$dbdate', '%d/%m/%Y' ), '%d/%m/%Y') as Date ;");
            $Result_date = mysql_fetch_array($takeResult);
            $result_date = $Result_date["Date"];
            $today = date("d/m/Y");
    if($result_date == $today)
        {
        echo "this is today $result_date, $today";
        }
        else { // there is my output: You can vote! 00/00/0000
        echo "You can vote! $result_date";
        }

现在可以正常使用(:

谢谢大家！

这篇关于使用PHP MySql从我的数据库中选择日期而无需秒的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！