current_timestamp() doesn't work -------------------------------- Key: HHH-3228 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3228 Project: Hibernate3 Issue Type: Bug Components: query-hql Affects Versions: 3.2.6 Environment: MySQL 5.0 Reporter: kronab Hello, I'm executing this HQL query: update phone_in_stock set state=1 where state=2 and dateSellingStarted<current_timestamp()-day(5) The following error occurs : Data truncation: Truncated incorrect datetime value: '5' With the following "delete" query : delete from phone_in_stock where state=0 and dateSellingStarted<current_timestamp()-day(5) No error occurs, but data is not erased. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira