Re: plsql / function / convert to date

"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 - 09:00:29 CST