[Gambas-user] Re; MySQL "timestamp"

[Benoit Minisini]

On mardi 17 juillet 2007, Gareth Bult wrote:
> Hi,
>
> Is there a trick to using a MySQL "timestamp" field from inside Gambas ?
>
> It seems to recognise a timestamp as a date type, but reads it looks
> totally corrupt.
>
> Using;
> $resultSet = connection.Exec("SELECT id,camera,event,image,stamp FROM cache
> WHERE id = &1",id)
>
> In the debugger I see (for example);
>
> $resultSet!stamp gives 01/01/-4801 -276:-2:-37
> (as opposed to 16-07-2007 17:55:40)
>
> .. "Date" fields seem to work fine ..
>
> ??
>
> tia
> Gareth.

According to the source code, the "timestamp" are managed, as the other 
date/time MySQL datatypes. 

Can you send me your database, or at least the table with just the offending 
record, in SQL text dump format?

Thanks in advance.

-- 
Benoit Minisini