Why dql in a way different DATETOSTRING andalusia SQL TO_CHAR?

rvalenzuela

hi
I have a problem with a query that does not return what I need, across the same SQL queery is ok, but by passing dql me back but does not filter data across the datetostring this is the query for DQL

SELECT distinct c.nrocaja, c.fecha, c.tipodocumento, c.rutcia, c.documento, c.imagenes, DATETOSTRING (f.r_creation_date, 'dd-mm-yyyy') as r_creation_date
from mcl_control c, f mcl_siniestro_vehiculo
where c.nrocaja = f.numero_caja

and SQL is formed:

SELECT DISTINCT c.nrocaja, c.fecha, c.tipodocumento, c.rutcia, c.documento, c.imagenes, TO_CHAR (f.r_creation_date, 'mm / dd / yyyy hh24: mi: ss') "r_creation_date" from mcl_control_sp c, f mcl_siniestro_vehiculo_sp where ((c.nrocaja = f.numero_caja)) and (c.i_has_folder = 1 and c.i_is_deleted = 0) and (f.i_has_folder = 1 and f.i_is_deleted = 0)

the query by the dql run through the Documentum Administrator, to observe the problem is that the 2 query SQL that was formed by the DQL takes TO_CHAR (f.r_creation_date, 'mm / dd / yyyy hh24: mi: ss ') I'm still asking DATETOSTRING (f.r_creation_date,' dd-mm-yyyy '), the results brings me enforma but repetitive. But if I quey the SQL and runs on Oracle and takes hours, as officials need

if you have any idea how to solve it. I appreciate it

i am working with documentum 6.0 SP1.

thanks in advance.

chaitk

In the SQL, you are seeing TO_CHAR (f.r_creation_date, 'mm / dd / yyyy hh24: mi: ss') "r_creation_date", even if you are requesting for DATETOSTRING (f.r_creation_date,' dd-mm-yyyy '). This is due to the fact that ContentServer retrieves the value of the date attribute in the oracle database standard format 'mm / dd / yyyy hh24: mi: ss' and later does the postprocessing on this value to give the reslut in the format requested by client.