Hello,

I'm trying to use a table containing a datetime field and i have the
following convertion problem:
------------------------

Invalid: expected a datetime in the DateTimeCol 'expiryDate', got <type 
'str'> '1000-01-01 00:00:00' instead

------------------------

I use the following table structure:

--------------------------
mysql> show columns from nodeProperties;
+------------------+------------------+------+-----+---------------------+-------+
| Field            | Type             | Null | Key | Default
| Extra |
+------------------+------------------+------+-----+---------------------+-------+
| hostname         | varchar(100)     |      | PRI |
|       |
| besteffort       | enum('YES','NO') |      |     | YES
|       |
| deploy           | enum('YES','NO') |      |     | NO
|       |
| expiryDate       | datetime         |      |     | 1000-01-01 00:00:00
|       |
| desktopComputing | enum('YES','NO') |      |     | NO
|       |
| arch             | text             | YES  |     | NULL
|       |
| os               | text             | YES  |     | NULL
|       |
| distribution     | text             | YES  |     | NULL
|       |
+------------------+------------------+------+-----+---------------------+-------+
------------------------------------


reading maling-list i found some similar problems but no solutions...
I also tried to override parameter getting with a _get_expiryDate but
this does not work.
I'm using 7.1


Best regards,
François



-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to