Can i Format List of Values ?

[system]

hi
can i format list of values ?
for example
the value i get in my lov is
01/01/2001 12:00:00 am

n i want to display it to the user in this format

01-jan-2001 or 01-01-2001

can i do this .?
help me out

regards

kiran

---

somasekharsai (BOB member since 2004-03-17)

[system]

One previous discussion:

How Do I Trim Off TIME in a Date Object?

Group, I know this is a real simple one, but I’m all twisted around trying to get this thing worked out . Here is what I got: Oracle 8.17 BO 5.14 I have a LOV for a Date Dimension Object in a Universe called FULL_DATE. I need to have this Date Object show 10/24/2002 or ‘MM/DD/YYYY’ when the user is prompted in a report. However, the prompt LOV shows 10/24/2002 12:00:00AM. I need to supress the Time stamp part of the date that the LOV brings in from the Oracle Table. I’ve trie…

Also a FAQ entry:
Designer FAQ Entry for Time on Date LOV Queries

---

Dave Rathbun (BOB member since 2002-06-06)

[system]

You can also check out my pdfs on how to remove the timestamp. You can use the same technique to format at the same time.

-RM

---

digpen (BOB member since 2002-08-15)

[system]

I’ve gotten through this by defining my date object as:
to_char(table.object, ‘MM/DD/YYYY’)

This formatting is included in the lov sql generated.

Or you could consider editing the lov sql yourself then ensuring you click the ‘Do not generate SQL before running’ check box.

---

Ron Briggs (BOB member since 2002-09-11)