[Gambas-user] Re; MySQL "timestamp"

[Gareth Bult]

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. 

-- 
Gareth Bult, Encryptec Limited 
Tel: 0845 25 77033, Mob: 07891 389657 
Email: gareth at ...1689... 
Statements made are at all times subject to Encryptec's Terms and Conditions of Business, which are available upon request.