Changing a date property with an update query
Hi, I'm trying to update a date property with an UPDATE DQL query, but the result is always a nulldate value. For instance: DQL> update dm_document objects set document_date = date('06/25/2010 00:00:00','mm/dd/yyyy hh:mm:ss') where r_object_id = '0900372380018c80'...objects_updated1 Now, when I dump the object, here's what…