Hibernate Community • View topic - Date Cast Convert Problem

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Date Cast Convert Problem

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

j0k3r0

Post subject: Date Cast Convert Problem

Posted: Sun Mar 07, 2010 10:57 am

Newbie

Joined: Tue Feb 02, 2010 3:38 am
Posts: 2

Hi,

When I run my below HQL, I got an HibernateQueryException.

Code:

FROM Appointment ORDER BY CAST(CONVERT(VARCHAR(10), ExtractionDateTime, 111) AS DATETIME) DESC, AppointmentDateTime ASC

Detail exception message is;

Code:

org.springframework.orm.hibernate3.HibernateQueryException: cast() requires two arguments [FROM com.poc.model.Appointment ORDER BY CAST(CONVERT(VARCHAR(10), ExtractionDateTime, 111) AS DATETIME) DESC, AppointmentDateTime ASC];

I can run the above cast-convert SQL-string in MS-SQL.
How can I write to work out in HQL.

Thanks,

Top

j0k3r0

Post subject: Re: Date Cast Convert Problem

Posted: Sun Mar 07, 2010 1:00 pm

Newbie

Joined: Tue Feb 02, 2010 3:38 am
Posts: 2

Hi,

I have solved this the other way round.
Solution is;

Code:

ORDER BY YEAR(ExtractionTime) DESC, MONTH(ExtractionTime) DESC, DAY(ExtractionTime) DESC, AppointmentDateTime ASC

Regards,

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum