RE: [PHP] Difficulties with datetime
| From: | Siim Einfeldt aka Itpunk | Date: | Tue, 05 Dec 2000 23:48:51 +0000 |
| Subject: | RE: [PHP] Difficulties with datetime | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-28785@lists.php.net to get a copy of this message | ||
> If the database accepts the state of NULL as the time and promotes it to
> midnight, there is no way to tell if the time was specified or if the time
> really was midnight.
not a good thing at all I must say:-)
> This is why we validate data entry. Garbage in (do a little datatype
> promotion), garbage out.
hard to do that as well, because user doesn`t have to write down
year,month,date,time...sometimes he can leave the time 'open' and so what
goes to database is....year-month-date 00:00:00. And there doesn`t seem to
be any way how I could make difference whether it`s 00:00 or 00:00....I
guess it`s impossible to write to the datetime column blahh-blaah-blaah
24:00:00?
S.