Re: Format Date Problem

From: Hoang C <hoang_c_at_bls.gov>
Date: Mon, 21 Apr 2003 10:21:17 -0400
Message-ID: <b80uot$ql1$1@blsnews.bls.gov>

select to_date(payperiod,'MM/DD/YYYY')

or ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY'

"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:21:17 CDT