Suppressing timestamp in LOV

[system]

There are numerous discussions on this… here are some older topics for you to review:

120×120 10.4 KB

How do I eliminate the time part in my date field? In designer I had set up my object “Process Date” to Trunc(Process Date) but by doing so the cost of my query is very high (We use oracle 8.1.7 and I did an explain plan). If I remove TRUNC function, Designer will add the time part to it providing incorrect results. Any suggestions? Is there any option I can change in PRM file or in supervisor?. Note: My table API_CLAIMS with the date column does not have time part stored in it. lbrewer (…

120×120 10.4 KB

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…

120×120 10.4 KB

Hi, If you take a datetime-field and make an LOV, how do I make the timestamp-part disappear in the LOV? It dont help with formatting the datetime-field with “YYMMDD”, in the object properties. Regards Christian Herrmann Sybase Sverige AB, SPS Listserv Archives (BOB member since 2002-06-25)

Dave

---

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