Re: How to convert Oracle native Date to date time

From: <fitzjarrell_at_cox.net>
Date: 3 May 2007 06:06:03 -0700
Message-ID: <1178197563.744829.93450@l77g2000hsb.googlegroups.com>

On May 3, 7:55 am, tracy <usatr..._at_hotmail.com> wrote:
> I get numbers like 1178002042 instead of date time info when I run
> access againt oracle.
>
> Does anyone know what the math is to convert this to date time, I
> assume it is telling me the number of seconds past some arbirtrary
> point in time like midnight 1-1-1980 ?
>
> Does anyone know what this arbitrary point in time is, if so I can
> work with the date time info as delivered via my current connection
> and applications.
>
> Thanks

Show us the query returnng this value; we can't tell you what is happening if you don't tell us exactly what you're doing.

David Fitzjarrell Received on Thu May 03 2007 - 08:06:03 CDT