Re: date format.

Hi,

The reason is that the LOV is returning Char, and in the absence of any explicit date conversion (to_date) the default Datetime format is applied, which includes seconds.
You could display minutes-only in the LOV but return a non-display value that includes seconds. Another possibility according to the doco is to set FORMS60_USER_DATETIME_FORMAT environment variable, specifying two alternative masks, as follows:
FORMS60_USER_DATETIME_FORMAT FXFMDD-MM-RRRR HH24:MI:SS|FXFMDD-MM-RRRR HH24:MI
where the pipe symbol '|' separates the masks.

youtz wrote in message <9ie8fl$e8u$1_at_news.worldcom.ch>...
>Hello,
>I have a "datetime" item and it's format mask is 'DD.MM.YYYY HH24:MI' I can
>enter manualy 01.07.2001 00:00, it works but if I get 01.07.2001 00:00 from
>a List Of Values I get an error : Invalid value for field.
> (It works with the format Mask : 'DD.MM.YYYY HH24:MI:SS' and a returning
>format from the LOV as 01.07.2001 00:00:00)
>
>
>
>
Received on Wed Jul 11 2001 - 06:57:45 CEST