Difficulties with datetime
| From: | Siim Einfeldt aka Itpunk | Date: | Tue, 05 Dec 2000 21:58:42 +0000 |
| Subject: | Difficulties with datetime | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-28767@lists.php.net to get a copy of this message | ||
SELECT DATE_FORMAT(col,'%H:%i') miski /.../ <- that`s in mysql
as the date&time is in the datetime column, the default value is
0000-00-00 00:00:00
If I want to know whether the time has been specified, then I do something
like this: if($miski == ""){
echo "thetime hasn`t been entered";
}
But what if the time was 00:00 (midnight)!? How can I make difference then
whether the time is midnight or it isn`t specified at all?
Thanks
Siim EInfeldt