[Serusers] DBText equivalent of MySQL datetime type?

[Daniel-Constantin Mierla]

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 at lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers
>
>  
>