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
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Jennifer" <jen_designs_at_hotmail.com> wrote in message
news:ac419b20.0304210545.28268f0d_at_posting.google.com...
> How do I format a date stored into a table as:
>
> 2002-02-28 00:00:00.0
>
> into
>
> 02/28/2002
>
> The sql statement is:
>
> SELECT PAYPERIOD
> FROM PAYPERIOD_Table
> ORDER BY PAYPERIOD ASC
>
> Any help would be appreciated.
>
> Thanks
>
> Jennifer
Received on Mon Apr 21 2003 - 09:22:50 CDT
