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 [EMAIL PROTECTED] 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 > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php