Re: Date Trigger Needed

Bill Long wrote:
>
> I need the SQL*PLUS code for the date conversion (I will it into a
> trigger) that will translate dates (both ways) between '12/31/96' and
> '31-DEC-96' formats.
>
> I know I can write this code. It would make my life easier if I could find
> existing, really complete routines.
>
> Thanks in advance,
> Bill Long
> Oracle DBA
> Portland, Oregon

If I understand you :

'12/31/96' -> '31-DEC-96' :
          TO_CHAR(TO_DATE(<char_like_12/31/96>,'MM/DD/YY'),'DD-MON-YY')

'31-DEC-96' -> '12/31/96' :
          TO_CHAR(TO_DATE(<char_like_31-DEC-96>','DD-MON-YY'),'MM/DD/YY')

Good Luck!
NastyNatal. Received on Wed Aug 14 1996 - 00:00:00 CEST