Re: pl/sql julian date conversion

[Quoted] [Quoted] Here's the result I'm getting with to_date:

  1* select to_date('97311','YYJJJ') from dual SQL> /
ERROR:
ORA-01810: format code appears twice

no rows selected

What is the proper syntax?

[Quoted] In article <6vvlvh$rua$1_at_news.eecs.umich.edu>,   fields_at_zip.eecs.umich.edu (Dr.Matt) wrote:
> In a certain newsgroup called comp.databases.oracle.tools,
> there was a poster called <tobrien_at_reveregroup.com>,
> for it means . And the
> Lord Bob spoke unto and bade
> relay
> <6vvkd1$iq7$1_at_nnrp1.dejanews.com> unto the people, saying:
>
> >Does pl/sql have a built in function to convert Julian dates to mmddyyyy
> >format? If not, does anyone have code for this type of conversion? Thanks.
>
> To_date()
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 13 1998 - 19:31:13 CEST