On 03/08/05 18:53, Cesc wrote:
Hi,
I am transfering the database stuff from mysql to dbtext, but is
giving me some problems. So far, after parsing the ":" and the spaces
and all these, it seems all the tables load ok ... till i try to save
a REGISTER into the location database.
It complains that the types of the value and the column where to save
the value are not the same ... i am guessing that setting the
"datetime" mysql-type as a "string" in dbtext is not ok ... what
should i do?
use it as an integer? then ... how do i write the date?
"2005-03-09 12:01:02" ... equals ... 20050309120102??
you have to convert it to unix time stamp -- in mysql use:
SELECT UNIX_TIMESTAMP(time) from acc;
Daniel
Tks in advance.
Cesc
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers