[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Need help Datefield Retrieval like this mmddyyyy

....
begin-select
to_char(to_date(start_date),'MMDDYYYY') &date_you_want
from ...
end-select
....

If start_date = '11-MAY-1997'
Result: '11051997'
Hope this helps!

At 12:06 PM 9/23/98 -0400, you wrote:
>Say I have a field called start date on a oracle db
>I want to retrieve in like this mmddyyyy
>
>How would I do this with sqr
>
>Thanks
>
>

Benjamin Le
System Development, ITS
Portland Community College
PO Box 19000 Portland, OR. 97280-0990 U.S.A.
Phone: (503)-977-4970 Fax:(503)-977-4987
E-mail: Mailto:ble@pcc.edu
PCC Web: http://www.pcc.edu