Re: Format Date Problem

From: Jennifer <jen_designs_at_hotmail.com>
Date: 21 Apr 2003 10:53:53 -0700
Message-ID: <ac419b20.0304210953.97b0099@posting.google.com>

"Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message news:<_8Toa.25568$Si4.13723_at_rwcrnsc51.ops.asp.att.net>...
> Yu are mistaking how dates/times are stored with how they are displayed.
> They are not stored in the format you indicate. Try using to_char to
> display the date as a string. eg select to_char(sysdate,'mm/dd/yyyy') from
> dual;
>
> Jim
>

Thanks Jim. That worked pefectly.

Jennifer Received on Mon Apr 21 2003 - 12:53:53 CDT