SAP Knowledge Base Article - Preview

1206067 - You have a date object that is represented in the following format, to_char(Date_field,"fmDay") "Day" but you cannot get the results to sort chronologically

Symptom

You have a date object that is represented in the following format, to_char(Date_field,"fmDay") "Day" but you cannot get the results to sort chronologically.

Query example:

select ename, date_field, to_char((date_field),'fmDay') "Day"
from emp
order by "Day";


Read more...

Product

SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI

Keywords

date sort to_char , 8848437 , KBA , BI-RA-DKI , Obsolete - Desktop Intelligence , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.