CODEWITHSUNDEEP
mysqlormcoldfusion
Tropicalista
Tropicalista

Reputation: 3137

Coldfusion Orm insert datetime: truncate error

I'm trying to insert a datetime into a mysql database using ORM.

I get this error:

Data truncation: Incorrect datetime value: '{ts '2013-11-21 06:33:45'}' 
    for column 'date' at row 1

I'm using this syntax to insert in database:

MyEntity.setCreationDate(Now())

I have set this in my object:

property name="creationDate" sqltype="datetime";

Upvotes: 1

Views: 269

Answers (1)

CfSimplicity
CfSimplicity

Reputation: 2363

Try changing your property from this:

property name="creationDate" sqltype="datetime";

to this

property name="creationDate" ormtype="timestamp";

Upvotes: 2

Related Questions