Re: date conversion in Form 4
From: Kenneth Ho <kenho_at_hk.super.net>
Date: Fri, 30 Sep 1994 11:01:23 GMT
Message-ID: <kenho.71.2E8BF003_at_hk.super.net>
Date: Fri, 30 Sep 1994 11:01:23 GMT
Message-ID: <kenho.71.2E8BF003_at_hk.super.net>
In article <36fj0m$1krh_at_yuma.ACNS.ColoState.EDU> litao_at_CS.ColoState.EDU (wu litao) writes:
>From: litao_at_CS.ColoState.EDU (wu litao)
>Subject: date conversion in Form 4
>Date: 29 Sep 1994 23:35:50 GMT
>Hi Everyone,
>The following select statement works fine under list of value of Form 4:
>select field1,date_field,field3 from a_table;
>BUT
>select field1,TO_CHAR(date_field,'ddMONyy'),field3 from a_table;
>DOES NOT!
>The error message is: FRM-40502: ORACLE error -- unable to read list of values
I haven't try this but this should work.
SELECT field1, TO_CHAR(date_field,'ddMONyy') "FORMATTED_FIELD", field from a_table;
Hope this help
Ken Received on Fri Sep 30 1994 - 12:01:23 CET