Hey all,
I'm trying to order a query based on 3 columns, one of which needs to be
sorted based on only the year of the timestamp. I've tried:
criteria.addOrderByDescending("to_char(year from
ARi_registration_indexes.REGISTRATION_DATETIME, 'YYYY')");
with not luck. Also the addSql with and order by statement isnt' working.
Any ideas?
Cheers,
Graham
========================================================================
Graham Lounder - Java Developer
CARIS Spatial Components Division
[EMAIL PROTECTED]
Phone: (506) 458-8533
Fax: (506) 459-3849
========================================================================
NO BINDING CONTRACT WILL RESULT FROM THIS EMAIL UNTIL SUCH TIME
AS A WRITTEN DOCUMENT IS SIGNED ON BEHALF OF THE COMPANY.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
