RE: [PHP] time() problem
| From: | Adam Voigt | Date: | Wed, 18 Sep 2002 17:26:49 +0000 |
| Subject: | RE: [PHP] time() problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-116765@lists.php.net to get a copy of this message | ||
Change it to an INT or a VARCHAR datatype, the mysql timestamp field
uses MySQL's date/time formmating. If you decide to let MySQL use it's
own date time format, use UNIX_TIMESTAMP(fieldname) to get the unix
timestamp from that date field.
Adam Voigt
adam.voigt@cryptocomm.com
On Wed, 2002-09-18 at 13:19, Savaidis wrote:
>
>
> Hello all!
>
> I use time() to keep UNIX seconds from 1970 to a timestamp(14) MySQL field.
> But when I read it (Dt_last) it is TO big compearing with "today=time()" in
> a php script that is only some seconds later.
> today : 1032350421 Dt_last: 20001101165838
>
> What can I do?
> Thanks!
> Makis
>
>
>
> Makis
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>