Hi,
I have a problem with sql query :
I want to list unique date from a table, with a special format
In a sql tool, i do :
select distinct (to_char(date_engagement,'yyyy-mm-dd')) jour from TACHE group by
DATE_ENGAGEMENT;
In castor, I try to do this :
l_query = "SELECT distinct(a.dateEngagement) from
fr.cmc.umm.mapping.tache.MTacheDateEngagement a" ;
Query oql = database.getOQLQuery(l_query);
execute ....
That's list all date ( and time ) , but there not ordered.
============
I try this to add a format to my sql query :
Query oql = database.getOQLQuery(l_query);
oql.bind(new java.text.SimpleDateFormat("a.dateEngagement",new
java.text.DateFormatSymbols(Locale.FRANCE)));
QueryResults l_results = oql.execute();
....
This is incorrect .
I think this is not the way to solve my problem.
================
Someone could help me ??
Thanks a lot.
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
