Re: plsql / function / convert to date

Jim Kennedy wrote:

> Clearly development doesn't understand what a database is for. They want
> their own proprietary "date" which makes no sense. Probably a testosterone
> thing.
> Jim
>
> --
> Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
> with family. Remove the negative part, keep the minus sign. You can figure
> it out.
> "Oliver Demus" <oliver_at_demus-online.de> wrote in message
> news:62e59750.0302271710.70459d6c_at_posting.google.com...
> > Hi Andrew,
> > yepp, I know, I don´t understand the desicion of the development. But
> > we have that now, and I have to find for that workarounds. I tried to
> > get a good answer, while they do it, but...
> >
> > Oliver
> >
> > ndrew Allen <andrew.allen_at_handleman.com> wrote in message
> news:<3E5E6810.5020202_at_handleman.com>...
> > > Oliver Demus wrote:
> > > > 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
> > > But Oliver,
> > > Oracle stores date/date+time info in an internal 7-byte structure that
> > > is only understood by Oracle. How you display it or the format of the
> > > date you load into the database is unimportant. The way dates and times
> > > are displayed is strictly a matter of local or personal preference and
> > > based upon such system/session parameters as:
> > > nls_date_format
> > > nls_date_language
> > > nls_dual_currency
> > > nls_territory
> > > nls_time_format
> > > nls_time_tz_format
> > > nls_timestamp_format
> > > nls_timestamp_tz_format
> > >
> > > So trying to 'universalize' a date into some number string of your own
> > > devising is pointless and in fact only makes things more difficult.
> > > --
> > > AjA
> > >
> > > >
> > > > "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
> > > >

Or someone coming from a mainframe background that has become to lazy to learn anything new. Either way ... a boat anchor.

Daniel Morgan Received on Thu Feb 27 2003 - 23:49:31 CST