Re: convert oracle-date to real date

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Fri, 09 Apr 1999 04:26:42 GMT
Message-ID: <37155bfa.4961056_at_netnews.worldnet.att.net>

On Thu, 08 Apr 1999 16:58:49 GMT, 100.69677_at_germanynet.de wrote:

>I'm searching for a oracle-tool to convert a oracle-date (the counter from
>01/01/70) to a real date. I had heard from a tool called ora2date and/or
>date2ora.

Oracle does not store dates as counters from 1/1/70. It's actually more complicated than that. Why are you converting the date? Do you need to get it into some other database?

Jonathan Received on Fri Apr 09 1999 - 06:26:42 CEST

This message: [ Message body ]
Next message: Peter L: "Re: how to print report in 132 column"
Previous message: Jonathan Gennick: "Re: Working Directory in SQL+"
In reply to: 100.69677_at_germanynet.de: "convert oracle-date to real date"
In reply to 100.69677_at_germanynet.de: "convert oracle-date to real date"
Next in thread: Peter L: "Re: how to print report in 132 column"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message