system
April 17, 2003, 1:31pm
1
The prompt for report date in my report shows the format dd/mm/yyyy HH:mm:ss. As the times are all 00:00:00 we would like to suppress this part of it.
We have thought that we could create a new table column with the new format but wondered if there was any other way of doing it.
norty303 (BOB member since 2003-03-19)
system
April 17, 2003, 1:43pm
2
There are numerous discussions on this… here are some older topics for you to review:
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 (…
Group,
I know this is a real simple one, but I’m all twisted around trying to get this thing worked out
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)
system
April 17, 2003, 2:08pm
3
Thanks Dave. I did actually do a search but it didn’t return anything…
norty303 (BOB member since 2003-03-19)
system
April 17, 2003, 3:07pm
4
Depends on your search terms. I searched for the combination of “LOV” and “timestamp*”. When I tried searching for “LOV” and “time*” I got too many results back.
Dave
Dave Rathbun (BOB member since 2002-06-06)
(BOB member since 2003-03-19)
(BOB member since 2002-06-06)