Re: plsql / function / convert to date

Hi again,
I think the idea behind that was, that we sell our product in different countries. And in that case, we don´t care about the format of a date. I think that is the one and only reason.

Oliver

"Guido Konsolke" <Guido.Konsolke_at_triaton.com> wrote in message news:<1046358009.609891_at_news.thyssen.com>...
> "Oliver Demus" <oliver_at_demus-online.de> schrieb im Newsbeitrag
> news:62e59750.0302270618.18ca9186_at_posting.google.com...
> > Hi everybody,
> >
> > off topic (german to Guido): Bin kein Frühaufsteher, bin im Moment in
> Canada.
> > thanks for the help, will use the advised procedure of Jim.
> >
> > But by the way, here is the procedure, wich converts the date into a
> number:
> > FUNCTION now
> > return number is
> > begin
> > return to_number(to_char((sysdate -
> > to_date(to_number(to_char(sysdate,'J')-2415019)+2415019,'J') )
> +
> > to_number(to_char(sysdate,'J')-2415019) )) ;
> > end;
> >
> > Thanks again
> > Oliver
>
> Hi Oliver,
>
> thanks for your answer and the function's code. Now I have something to
> do when the weather turns bad again: think about why one would use such a
> function.
>
> Greetings,
> Guido
Received on Thu Feb 27 2003 - 12:36:38 CST