Hibernate Community • View topic - HQL query, current

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

HQL query, current_timestamp()

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

kronab

Post subject: HQL query, current_timestamp()

Posted: Wed Apr 02, 2008 9:21 am

Newbie

Joined: Wed Apr 02, 2008 9:01 am
Posts: 4

Hello,
I'm executing this HQL query:

Code:

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'
I don't see where is the problem in the request.
With the following "delete" query :

Code:

delete from phone_in_stock 
where state=0 and dateSellingStarted<current_timestamp()-day(5)

No error occurs, but data is not erased.

Have you got an idea of the problem ?

Top

kronab

Post subject:

Posted: Thu Apr 03, 2008 8:36 am