Re: Date formatting problem

[Benjamin Le <ble@PCC.EDU>]

select to_char(to_date('06/21/99','MM/DD/YY'),'DD-MON-YYYY') from ...

At 05:02 PM 7/26/99 +0000, you wrote:
>Hello all,
>
>I am sorry, if this has been discussed 'n' number of times before.
>
>I am trying to convert date from source file in the format
>'06/21/99'  to '21-JUN-1999'.  Could u pl let me know the most efficient way
>of achieving this?  I am currently using the 'Format_datetime' procedure
>thru the datetime.sqc, but not achieving the correct results.
>
>Thanks
>DJ
>
>
>_______________________________________________________________
>Get Free Email and Do More On The Web. Visit http://www.msn.com


Ben Le
ITS - Sylvania CC-224
Voice:(503)-977-4970  Fax:(503)-977-4987
Mailto:ble@pcc.edu