Interested to Buy Any Domain ? << Click Here >> for more details...
in a database date formate is in dd/mm/yy. In my report I
want when I prompt the date coloumn it should be
displayed in (yyyy/mmm/dd)format.
how could I do this
plse send me as soon as possible.
- 3 Answers
- 7906 Views
- I also Faced
- E-Mail Answers
Answer Posted / aditya
create a derive table for that
select to_char(hire_date,'yyyy/mmm/dd') as date from
employees
it will work when you use in the prompt
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is the difference between the public object&schema object?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
How to generate the report from excel sheet?
Can you please send me the migration related issues .
What we need to discuss with designer before starting the universe designing.
what is xcelsius architecture?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
What are the data types present in bo? What happens if we implement view in the designer and report?
how to prepare the documentation in business objects and where to get the requirement?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
What is the difference between absolute and relative div positioning?
How to open a universe with out using the Designer ??
Explain when we use aggregate awareness function in designer?
